Formula to predict a future date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Take a look at the WORKDAY function

--
Regards,

Peo Sjoblom

(No private emails please)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Excel to calculate future dates with various intervals 8
Excel date & time prediction in excel. 0
Formulas--NEED HELP! 4
Formula to skip holidays 9
Calculate End Date Using Start Date and No. of Days excluding specific days. 0
A tale of two suppliers 5
Need Formula Help 6
Finding the right function & formula 4

Back
Top