Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate Future Date but don't want
Hello.
I have some tasks that where the duration is in days (not workdays). What formula would I used to calcuate a future date and if it lands on a weekend to "round up" the future date to the following Monday (or round down the Friday) I know of the workday function but I believe the day input is the number of workdays needed (where I have total days needed). -- Thanks, Morocco Mole |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculate future age date by birthdate | Excel Discussion (Misc queries) | |||
Tricky Date calculation: How to calculate a future date | Excel Discussion (Misc queries) | |||
formula to calculate future date from date in cell plus days | Excel Worksheet Functions | |||
calculate future date | Excel Worksheet Functions | |||
Calculate sequential value for future date | Excel Worksheet Functions |