Excel date changes when copied and pasted

Question

Excel date changes when copied and pasted

Anonymous

When copying from data sheet date values and pasting them to an other sheet, the dates are changed 4 year and one date earlier. How to correct?

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

0 additional answers

Answer 1

HansV 462.6K

The source workbook uses the 1904 date system (standard on Mac) and the other doesn't (standard on Windows).

See https://support.microsoft.com/en-us/help/214330/differences-between-the-1900-and-the-1904-date-system-in-excel for detailed information and instructions on switching between the two systems.

0 comments

Share via

Excel date changes when copied and pasted

0 additional answers