Network days question
Annette wrote:
I used the formula =NETWORKDAYS(K15,L15) to determine the number of days
between two cells; however, one of my cells
1/16/06 1/16/06
reports the above as 1 and the following
7/1/06 7/1/06
reports the above as 0.
Why are they reporting difference - I checked to assure formatting is the
same. I want it to report one when there is only one day.
Thanks!
Hi Annette,
One guess would be that Saturday the 1st of July is not counted as a
workingday but Monday the 16th of Jan is.
Regards,
Bondi
|