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