Formula to predict a future date
 

I need a formula or function that will enable the prediction of the future
date based upon a 40 hour work week.
Example (simplified) - Promised delivery of something in 1 week (40 hours).
Order recieved on Thursday, 3 November. Delivery due on Thursday, 10 November.
Typical lead times could be 15 weeks or more.
Thank you in advance.

Formula to predict a future date
 

Take a look at the WORKDAY function

--
Regards,

Peo Sjoblom

(No private emails please)


"Bill Eagle eye" <Bill Eagle wrote in message
...
I need a formula or function that will enable the prediction of the future
date based upon a 40 hour work week.
Example (simplified) - Promised delivery of something in 1 week (40
hours).
Order recieved on Thursday, 3 November. Delivery due on Thursday, 10
November.
Typical lead times could be 15 weeks or more.
Thank you in advance.