networkdays function

M

Martin B

I'm trying to use the networkdays function to return the number of working days between 2 dates which seems like the correct function however when I use 2 dates, 7 days apart, the function returns 6 rather than 5 i.e monday to friday working.
Am I doing something wrong?

Thanks in anticipation.
Martin
 
T

T. Valko

What are the 2 dates your using in the formula?

--
Biff
Microsoft Excel MVP


I'm trying to use the networkdays function to return the number of working days between 2 dates which seems like the correct function however when I use 2 dates, 7 days apart, the function returns 6 rather than 5 i.e monday to friday working.
Am I doing something wrong?

Thanks in anticipation.
Martin
 
G

Gord Dibben

The function includes start and end dates in its calculation.

Start date in A1 1/1/2008

End date in A7 1/7/2008

=NETWORKDAYS(A1,A2) returns 5 for me in Excel 2003

If you add 7 days to 1/1/2008 and use 1/8/2008 you are actually calculating for
8 days and would return 6 workdays


Gord Dibben MS Excel MVP
 

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

Top