Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Solved it by using WORKDAYS in lieu of NETWORKDAYS.
Thank you all, in any case. John Bartley K7AAY wrote: David G wrote: NETWORKDAYS seems to count the workdays including the start and end date. For example, NETWORKDAYS(TODAY(),TODAY()) = 1. So, NETWORKDAYS(TODAY(),TODAY() + 1) = 2, which is what you got. Simply subtract 1 to get the result you expected to get. But make sure the second date is greater than the first date before you do or else the net workdays from today to yesterday will give you -2. Cheers, David G Well, if there's a Sat or Sun involved, subtracting -1 does not work well. If I am counting Mon-Fri days only, that would work OK, but I am trying to create a timeline generator which lets me plug in the start date, the time for each task, and get the end date, and if two dates span a weekend, the -1 screws up the calculation. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Net Workdays | Excel Discussion (Misc queries) | |||
Calculating dates - complex scheduling problem | Excel Worksheet Functions | |||
Workdays | Excel Programming | |||
Stumper WORKDAYS Problem | Excel Discussion (Misc queries) | |||
Aircraft Scheduling Problem VBA code needs adjustment. | Excel Programming |