NETWORKDAYS

R

rhhince

I have two dates Feb. 1@ 17:00 and Feb. 14 @17:00. There is exactly 13
days apart. I use NETWORKDAYS to skip weekends and get 11 days instead
of 9 days. Here is my formula:
=NETWORKDAYS(C25,E40)
It should have skipped 2 weekends, but skipped 1 weekend only.
Any suggestions. Thanks.
 
A

alanglloyd

I have two dates Feb. 1@ 17:00 and Feb. 14 @17:00. There is exactly 13
days apart. I use NETWORKDAYS to skip weekends and get 11 days instead
of 9 days. Here is my formula:
=NETWORKDAYS(C25,E40)
It should have skipped 2 weekends, but skipped 1 weekend only.

No; NETWORKDAYS() ignores time in the DateTime values. 1st to 14th is
14 inclusive days, less 2 weekends = 10, which you should have got (&
I did).

If you only count a day if worked between stated hours, then you must
implement that yourself with conditional functions (including
specified start & finish times) on the dates specified in
NETWORKDAYS().

Alan Lloyd
 
R

rhhince

Thanks for your input. I found that if I use this formula it corrected
my problem.

=NETWORKDAYS(C25,E40)-1-MOD(C25,1)+MOD(E40,1)
 

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