networkdays function

[whahappened...]

my two dates:
h131=1/14/2008 i131=1/22/2008
formula used: =networkdays(h131, i131)
answer given = 7
real answer should be 5 correct (subtract sat and sunday and get 5)

thanks

 

[David Biddulph]

If you know that the end days are not weekend dates, then just subtract 2
from the NETWORKDAYS result.
If the end days might be weekend dates, you'll need to test them (with the
WEEKDAY function), and then subtract as appropriate.

 

[Ron Rosenfeld]

OHHHHHHHHHHHHHHHHHH

So I guess I need it to NOT count the actual days, IE: not count the 14th
and the 22nd as days either! Now I get why it is getting the 7, but how can
I get it to calculate only the days within the boundary, NOT including the
boundary?

=networkdays(h131+1, i131-1)


--ron

 

[Ron Rosenfeld]

If you know that the end days are not weekend dates, then just subtract 2
from the NETWORKDAYS result.
If the end days might be weekend dates, you'll need to test them (with the
WEEKDAY function), and then subtract as appropriate.

Or, he can just add one to the start date, and subtract one from the end date
--ron

 

[David Biddulph]

Yes, that sounds much simpler, Ron.