| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation of workdates
I have a spreadsheet that calculates a future date based upon the number of
free days allowed from a pick up date. Example: Pick up date 4/7/2009, number of free days 14, last free date 4/20/2009. However if this date returns a weekend date I need it to tell me the prior work date available less any holidays. Does anyone know the formula for this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculation using IF | Excel Worksheet Functions | |||
| Calculation using IF | Excel Worksheet Functions | |||
| Multi threaded calculation (multi CPU) - impact on calculation spe | Excel Discussion (Misc queries) | |||
| How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
| How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
Threaded Mode
