Incorrect dates when copying to a new workbook??

[Corey]

Hello. I'm hoping someone else has encountered this
problem and knows how to fix it. I'm working with some
older spreadsheets that have continually been updated for
many years now. When I try to copy the sheet to a new book
or just copy the cells of dates and paste them into a
different workbook, the dates are behind by exactly 1,462
days. For example, I'll copy 12/31/03 into a new work book
and it will appear as 12/30/99. How do I fix this?

Thank you!

Corey

 

[Norman Harker]

Hi Corey!

You appear to have your new setting at the 1904 date system:

Use:

Tools > Options > Calculation
Uncheck "1904 Date System"
OK

 

[Jason Morin]

There's a lack of consistency in the date system between
the new workbook and the old ones. You can set it under
Tools > Options > Calculation tab > 1904 date system box.

For more information about the date system:

http://www.cpearson.com/excel/datetime.htm#SerialDates

HTH
Jason
Atlanta, GA

 

[Corey]

Thanks fellas! That was exactly my problem.

Corey