| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
workdays formula ends on weekend date
I'm trying to calculate end dates similar to MS Project based upon a start
date and duration in workdays. Start Date = 1/3/2006 Workdays = 28 - 1 day adjustment to get the END DATE Holidays = ignore for now, not using it Therefore... formula is WORKDAYS(1/3/2006,28)-1 = 2/9/2006 this is okay, but when increased to 29 days the end date should be 2/10/2006 but Excel jumps to 2/12/2006 which is a Sunday. Why? What am i doing wrong? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trending Formula Results by Date | Excel Worksheet Functions | |||
| Match then lookup | Excel Worksheet Functions | |||
| NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Threaded Mode
