View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bondi
 
Posts: n/a
Default 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