Thread: NETWORKDAYS = 0
View Single Post
  #5   Report Post  
ann
 
Posts: n/a
Default

Thanks to all who replied. It only happens intermittently so maybe it is
something with the spreadsheet. It is very old and has several anomalies.
--
TIA, Ann


"ann" wrote:

I have a networkdays equation that equals zero sometimes and equals one other
times when the start and end dates are the same. All of my date fields are
formatted as m/d/yyyy.

start date end date #days
8/4/2005 8/4/2005 1
8/16/2005 8/16/2005 0

--
TIA, Ann