NETWORKDAYS

[R Quigley]

When I use the networkdays function in Excel 2000, it
gives inconsistant results. (For these examples, I'm
leaving out holidays.) For example, NETWORKDAYS
("4/1/04","5/1/04") results in 22, which is correct...
there are 22 weekdays between April 1 and May 1 this
year. If I put in NETWORKDAYS("5/1/04","6/1/04"),
however, it tells me there are 22 weekdays in May, which
is wrong. There are only 21. Is there a problem with the
program, or am I doing something wrong?

Thanks

 

[Newbie]

I believe it includes the last date and therefore it only appeared to work
for April because May 1st was a Saturday.
To get the number of networkdays in May you would need to enter
=NETWORKDAYS(DATE(2004,5,1),DATE(2004,5,31))

HTH