networkdays function
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
"Jeff Boyce" wrote:
We aren't there. We can't see what you're looking at.
More specific description is likely to lead to more specific suggestions...
Regards
Jeff Boyce
Microsoft Office/Access MVP
"whahappened..." wrote in message
...
i installed the analysis pack and yet it is still calculating one extra
weekend. I attempted with the date function (=date(year, month, day)) and
with just a normal date; however, it is still giving me 7 instead of 5!
What
I am doing wrong!?
|