Then, select either of the following option buttons.Īdd The dates must be shifted up by four years and one You can correct shifted dates by following these steps: If you paste data from a Macintosh file into a PC file you can end up with dates that are off by four years and one day.
The default for windows is January 1, 1900. The default for the Macintosh is to start with January 1, 1904. If you use Excel a great deal, you might already have been aware of the fact that Macintosh and Windows may use different calendars for dates. It all looked lovely when I got it except for the fact that many of the dates were for 2013 and beyond, which didn’t make sense for, say, the date an application was received. Then, both files were opened on a Mac and the rows from one file pasted into the other. One of the files was an Excel file on a Mac. The first one involved two Excel files sent to me from one of my favorite clients. Two incidents happened lately where results I expected to be the same turned out to be different.
What do when dates in your Excel file are off by four years
