NETWORKDAYS

[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.

 

[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

 

[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)