[quoted text, click to view]

Hi Bob,

But I do!

A very early version of Excel had an error in the calculations for leap
years: it mistakenly assumed that 1900 was one, whereas in reality, it
wasn't. They could not fix this in later versions, because that would
break compatibility. (That's why you now have the option to choose for a
date representation that starts in 1904 instead <g>).

This means that date values in Excel of 1 through 59 can be converted to
date by adding that number of days to 1899-12-31, date values of 61 and
above by adding it to 1899-12-30, and the number 60 does not represent a
valid date at all.

--
Hugo Kornelis, SQL Server MVP