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
|