networkdays vs days360
 

Hi
Could anyone tell me why when I use NETWORKDAYS I get a different
result than when I use DAYS360 even though there are no weekend days in
the particular range?

eg. NETWORKDAYS (A2,B2) or (19/12/2005, 22/12/2005) comes up with the
answer 4

It comes up with the answer 4.

Whereas when I use DAYS360 for the same equation, I get 3.

There are no weekend days in this date range?

Does NETWORKDAYS include both end dates in the date range and DAYS360
just subtract 1 from the other? I would have thought they would be
consistent.


--
Toothfaerie
------------------------------------------------------------------------
Toothfaerie's Profile: http://www.excelforum.com/member.php...o&userid=34958
View this thread: http://www.excelforum.com/showthread...hreadid=546933

networkdays vs days360
 

Networkdays counts the number of physical days in the range.
Days360 counts the number of days "between" the dates.

Similar to this

| | | |

4 dashes but only 3 spaces

HTH
Martin