Thread
:
Formula to predict a future date
View Single Post
#
2
Peo Sjoblom
Posts: n/a
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.
Reply With Quote