networkdays function

  • Thread starter Thread starter whahappened...
  • Start date Start date
W

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
 
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.
 
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?
Click to expand...

=networkdays(h131+1, i131-1)


--ron
 
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.
Click to expand...

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