| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add no. of days to a workday to get new workday?
Looking for a formula so I can add a number of workdays to an existing date
to get the new workday (i.e. existing date + workdays = new workday). Here's an example: 1) Starting point: 4/15/10 2) Add: 4 3) Result: 4/21/10 (because it's 4 workdays after start date -- skipped weekend) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Add no. of days to a workday to get new workday?
Look in Help for details on the WORKDAY() function
"blswes" wrote: Looking for a formula so I can add a number of workdays to an existing date to get the new workday (i.e. existing date + workdays = new workday). Here's an example: 1) Starting point: 4/15/10 2) Add: 4 3) Result: 4/21/10 (because it's 4 workdays after start date -- skipped weekend) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Workday | Excel Worksheet Functions | |||
| WORKDAY | Excel Worksheet Functions | |||
| WOrkday function - change working days | Excel Worksheet Functions | |||
| Workday Help | Excel Discussion (Misc queries) | |||
| Is there a WorkDay() type function that count all days except tho. | Excel Worksheet Functions | |||
Linear Mode
