Copying dates between Excel documents

  • Thread starter Thread starter philb101
  • Start date Start date
P

philb101

I have noticed that when I copy a date eg/ 23/02/04 (UK format) from on
Excel document to another the date becomes 22/02/00.

Has anyone comes across this, its really infuriating as I have t
redate everything again

Thank
 
XL has two date systems, the Windows default 1900 date system, in which
the 0-base date is 31 December 1899, and the MacXL default 1904 date
system, in which the 0-base date is 1 January 1904. The systems differ
by 4 years and a day.

To resolve your issue, make sure that both workbooks have the same date
system selected (Tools/Options/Calculate, check or uncheck the 1904 date
system checkbox).
 
Back
Top