Buger or ....? about Networkdays function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Put this data in the cel
=Networkdays(2004-4-29,2004-4-26)
Then return 3 ,but the correct result is 4

=Networkdays(2003-4-29,2003-4-26)
Then return 4 ,but the correct result is 2

ALL DATE concern 4-26 will get a wrong result

can anybody kown why ? or what 's wrong
 
Hi
your values are not interpreted as 26-Aprl-2004 but as the
date returned by 2004 minus 4 minus 29 = 1971 = 24-May-1905

So try
=Networkdays("2004-4-26","2004-4-292)
or to be safe:
=Networkdays(DATE(2004,4,26),DATE(2004,4,29))
 
Back
Top