Forum Discussion
Date changes when copied and pasted on another excel document
One workbook uses the so-called 1904 date system, and the other doesn't. The difference between the two systems is 4 years and 1 day (1462 days).
To correct the dates:
Enter 1462 in a cell.
Copy the cell.
Select the future dates.
Right-click in the selection and select Paste Special... from the context menu.
Alternatively, click the lower half of the Paste button on the Home tab of the ribbon and select Paste Special...
Select Subtract.
Click OK.
Repeat as necessary for other ranges.
Clear the cell with 1462 when you're done.
Remark: the 1904 date system can be toggled on/off in File > Options > Advanced, under 'When calculating this workbook'. It is a per-workbook setting.
One workbook uses the so-called 1904 date system, and the other doesn't. The difference between the two systems is 4 years and 1 day (1462 days).
To correct the dates:
Enter 1462 in a cell.
Copy the cell.
Select the future dates.
Right-click in the selection and select Paste Special... from the context menu.
Alternatively, click the lower half of the Paste button on the Home tab of the ribbon and select Paste Special...
Select Subtract.
Click OK.
Repeat as necessary for other ranges.
Clear the cell with 1462 when you're done.
Remark: the 1904 date system can be toggled on/off in File > Options > Advanced, under 'When calculating this workbook'. It is a per-workbook setting.
