"I ran a spreadsheet for the Adopters List Spay/Neuter and the adopted dates (dates) came up as 2019 instead of 2015. Do you know why this would happen when it was converted into xlsx?"
To correct, try these steps:
http://techsupport.foreverwarm.com/excel-date-changes-by-four-years
There’s a little known feature of Excel to format dates two ways:
1900 Date System
1904 Date System
In the 1900 date system, the first day that is supported is January 1, 1900. When you enter a date, the date is converted into a serial number that represents the number of elapsed days since January 1, 1900
In the 1904 date system, the first day that is supported is January 1, 1904. When you enter a date, the date is converted into a serial number that represents the number of elapsed days since January 1, 1904.
Here’s the problem
If you bring a spreadsheet that was formatted in a version of Excel where the 1900 Date System was used, and put that data in an Excel spreadsheet using the 1904 Date System then the Excel date code is interpreted differently.
For example: July 5, 1998 will show as 35981 in the 1900 Date System and 34519 in the 1904 Date System.
How to change the Excel Date System in Excel 2007 and 2010
– Open or switch to the workbook
– Click the File menu, select Options
– Click Advanced and scroll down to the When Calculating this Workbook
– Check or uncheck the Using 1904 Date System option
Here’s an article that shows you how to correct these shifted dates in the new spreadsheet if you need to.
https://support.microsoft.com/en-gb/kb/214330
Comments