Formula to predict a future date

B

Bill Eagle eye

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.
 
P

Peo Sjoblom

Take a look at the WORKDAY function

--
Regards,

Peo Sjoblom

(No private emails please)
 
Top