The problem is when I left the cell BLANK, the formula still generate a
result, that's why I think that Excel assume the blank cell as a certain
date, and calculate some type of result even though the cell is blank!!!
"Bernard Liengme" wrote:
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?