Date changes back 4 years when copying

[Dave]

When we copy a date from an excel 2000 worksheet and paste
it in an excel XP worksheet the year will move back four
years. Any ideas?

 

[Alan]

Go Tools > Options > Calculation and make sure both files have '1904 Date
System' either checked or unchecked, ie both the same,
Regards

 

[JE McGimpsey]

When we copy a date from an excel 2000 worksheet and paste
it in an excel XP worksheet the year will move back four
years. Any ideas?

Your XL2000 worksheet is using the 1904 date system
(Tools/Options/Calculate), while your XP worksheet is using the 1900
date system.

Change the workbooks to use the same system.

 

[Harald Staff]

Four years and one day ? One file is set to 1900 calendar (Windows standard)
and the other to 1904 (Mac standard). Settings are in Tools > Options menu.
Add 1462 to the dates to fix them.

HTH. Best wishes Harald