Go Back   TechArena Community > Technical Support > Computer Help > Office Help > Microsoft Project
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Formula to calculate date of delivery

Microsoft Project


Reply
 
Thread Tools Search this Thread
  #1  
Old 06-10-2011
Member
 
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

Reply With Quote
  #2  
Old 07-10-2011
Member
 
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).
Reply With Quote
  #3  
Old 08-10-2011
Member
 
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
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > Microsoft Project
Tags: ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Formula to calculate date of delivery"
Thread Thread Starter Forum Replies Last Post
Need a formula to calculate years/days/months among several date in Excel Kumar esan MS Office Support 2 16-02-2012 07:05 PM
How to calculate formula as per run rate in Excel (Cowherd) MS Office Support 2 15-02-2012 03:58 PM
I am looking for a formula to calculate compound interest in Excel Corey Dunnett MS Office Support 3 03-02-2012 05:05 PM
Need a simple formula to calculate EV and PV seperately CooRa Microsoft Project 2 17-09-2009 10:16 PM
Changing start date and creating formula for finish date stringse Microsoft Project 1 11-09-2006 01:13 PM


All times are GMT +5.5. The time now is 10:50 PM.