We have an option in SharePoint to export the SharePoint list to an excel. When a user extracts a report and enable the "user 1904 date system" under Excel Options-> Advanced->When calculating this workbook, the data columns in the excel would get added by 4 years and 1 day. For example: If the date column has the value 08/03/2019, it would get converted to 09/03/2023. Please click here to know more about the excel date systems. Please follow the steps to correct the shifted dates! Correcting Shifted Dates If you link from or copy dates between workbooks, or if you change the date system for a workbook that already contains dates, the dates may be shifted by four years and one day. You can correct shifted dates by following these steps: 1. In an empty cell, enter the value 1462. 2. Select the cell. On the Edit menu, click Copy . Note In Excel 2007, select the cell, and th...