View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Annette
 
Posts: n/a
Default Network days question

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!