Knowledge Article View - Customer Support

Date values might be incorrect when you use the XLS or XLSX engines to import Excel files. The dates are off by 60 years and one day. For example, the date 02/24/2003 is imported as 02/25/2063.

To circumvent the problem, use one of the following methods:

In Excel, select the cells and format them as date values rather than as generic columns.
If you cannot change the data, subtract 21,916 from the date value. Here is an example:

mynewdate=mydate-21916; 
format mynewdate mmddyy10.;

Date values might be incorrect when you read Microsoft Excel files with the XLS or XLSX engines