| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating new date by entering number of additional workdays
Would love some assistance with the following:
If I have a start date in a cell (A1), I am hoping to enter a number of additional workdays into another cell (B1), resulting in a new date -- skipping weekends -- in a third cell (C1). Looking for the formula for C1. If it helps, here's an example: * Start date = 4/1/10 (which is a Thursday) * Additional workdays = 5 * Solution = 4/7/10 (because it skipped the weekend) Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating number of workdays between 2 dates | Excel Worksheet Functions | |||
| Adding Number of Workdays to a Date (Projects) | Excel Discussion (Misc queries) | |||
| Calculating number of workdays | Excel Worksheet Functions | |||
| How do I find total number workdays from a range of date | Excel Worksheet Functions | |||
| Adding a number to a date as workdays | Excel Worksheet Functions | |||
Threaded Mode
