Results 1 to 3 of 3

Thread: Formula to calculate date of delivery

  1. #1
    Join Date
    Oct 2011
    Posts
    1

    Formula to calculate date of delivery

    Hi, I am new to MS project 2007, I have a schedule of dates for work to commence on. we need to order items 4 weeks before the start date for that task.

    If possible is it able to calculate when we need to order 4 weeks before the start date for that task and for it to be on a specific day on that week i.e thursday.

    Thankyou

  2. #2
    Join Date
    Jul 2009
    Posts
    67

    Re: Formula to calculate date of delivery

    Try this as a start: Create a task called say "Order items" and give it a durration of zero to make it a milestone. In its predecessor column enter the ID of your work task, make it start-start and give it a lead of 20 days (it should look then something like 35SS-20d). Project will then calculate the date that you should order the items but it may not be a Thursday (sorry but cant help with that).

  3. #3
    Join Date
    Dec 2006
    Posts
    489

    Re: Formula to calculate date of delivery

    Shoppingboy got you 99% there with a start to start and a lead on the task.

    Then create a calendar with the only working day set to all Thursdays. If you give the "Order Items" task a duration of anything greater than zero (perhaps 10 minutes to place the call) and assign the custom calendar to the task, you should be all set. The lead places the task a minimum of the lead days before -- the custom calendar will force it to schedule only on Thursday.

    I hope this helps.
    Julie

Similar Threads

  1. Replies: 2
    Last Post: 16-02-2012, 07:05 PM
  2. How to calculate formula as per run rate in Excel
    By (Cowherd) in forum MS Office Support
    Replies: 2
    Last Post: 15-02-2012, 03:58 PM
  3. I am looking for a formula to calculate compound interest in Excel
    By Corey Dunnett in forum MS Office Support
    Replies: 3
    Last Post: 03-02-2012, 05:05 PM
  4. Need a simple formula to calculate EV and PV seperately
    By CooRa in forum Microsoft Project
    Replies: 2
    Last Post: 17-09-2009, 10:16 PM
  5. Changing start date and creating formula for finish date
    By stringse in forum Microsoft Project
    Replies: 1
    Last Post: 11-09-2006, 01:13 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •