View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
whahappened... whahappened... is offline
external usenet poster
 
Posts: 2
Default 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!?