| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Networkday question
If you enter DATE(2008,10,1) as the Start_date and 10/1/08 as the End_date it
shows a difference of N=1 workday. Which means the system is subtracting 39722 from 39722 and getting a total of 1. If you enter DATE(2008,11,1 ) as the Start_date and 11/1/08 as the End_date it shows a difference of N=0 workdays. Which means the system is correctly subtracting 39753 from 39753 and getting a total of 0. What is causing the difference when the same formula is used? Is this a glitch in the system? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| networkday - datedif | New Users to Excel | |||
| 6 day/week function ie:networkday | Excel Worksheet Functions | |||
| Businessday (Networkday) Function | Excel Discussion (Misc queries) | |||
| Networkday Calendar | Excel Discussion (Misc queries) | |||
| NETWORKDAY function problem - starting on weekends | Excel Discussion (Misc queries) | |||
Threaded Mode
