I prefer to think of date 0 as midnight on the day that will be Sunday
1/1/1900 in one nanosecond later!
Then I do not need worry what 00/01/1900 means!
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Neon520" wrote in message
...
I doing some date calculation, it seems like Excel assume some date when I
left the cell blank, anyone know what does Excel assume when the cell left
blank for the date?