View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default Networkday question

That's the way Excel counts it; start and end date the same means one day.
But 2008,11,2 is not a workday, so it doesn't count

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"gcw" wrote in message
...
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?