The serial number for this particular date is


39562


if you change the format from date to general what do you get?

For year 1905 the serial number would be between 1828 and 2192


serial number is the number of days since Jan 0 1900 given that Excel AD
starts then (at least for Windows)

--


Regards,


Peo Sjoblom

"dbdewitt" wrote in message
...
As I understand it, the YEAR formula should return the year to which the
formula relates. I have a date of 4/24/2008 in a cell (let's say it's in
cell B2), when I enter the formula (let's say in cell A2) "=YEAR(B2)", the
result is 1905 where the result should be 2008. Can someone tell me what
I'm
missing?