| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If formula for date range | Excel Discussion (Misc queries) | |||
| formula IF returning current date | Excel Worksheet Functions | |||
| Excel formula with date constraints | Excel Discussion (Misc queries) | |||
| Formula with date constraints | Excel Worksheet Functions | |||
| Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
Linear Mode
