networkdays vs days360

T

Toothfaerie

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.
 
M

MartinW

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate elapsed working days 6
Days360() is only approximate 3
DAYS360 where Start Date is Static and End Date is Latter of Two Dates 1
Calculation of working days between two dates 1
Calculate workdays in a month. 4
NETWORKDAYS formula 5
time interval between dates incl weekends excl holidays 7
Reverse Networkdays?? 2

Top