number represents date in Excel

[findhelp]

Hi,

Accoding to How to use dates and times in Excel:
"the number 32331.06 represents the date and time 7/7/1988 1:26:24 a.m"

I then think, the integer part, 32331, represents the total days between 1/1/1900 and 7/7/1988.
However, in VBA, I tried
Debug.Print DateDiff("d", "1/1/1900", "7/7/1988")
and got result 32329

Anything I misunderstood?

 

[njimack]

It's actually the number of days since 31/12/1899, since 1/1/1900 was day 1. Having said that, I don't know why the VBA DateDiff function gives a different result to the Excel DATEDIF function.

 

[circledchicken]

Hi,

I think this has to do with the assumption that 1900 was a leap year when using the 1900 Date System, which was carried over from older spreadsheet systems for compatibility. I don't think the DateDiff function in VBA relies on this assumption.

There should be a lot more info if you Google it, for example see:
XL: The 1900 Date System vs. the 1904 Date System
Differences between the 1900 and the 1904 date system in Excel

 

[findhelp]

Thanks a lot for all your helps. I have never known those things.