SharePoint list exported to Excel has different dates

Copper Contributor

One of our users has this problem:
The dates appear correctly for her in the SharePoint list, but once she exports the list to excel as a query.iqy, the dates change.

Here an example:
(SharePoint list view)
Entry A: 25.03.2021
Entry B: 20.01.2021

 

(Exported in excel view)
Entry A: 26.03.2025
Entry B: 21.01.2025

1 Reply

@YvonneP I note that you got no replies to this - Did you ever figure out what the issue was?

 

My field is Date and Time and it's automatically extracted from email metadata (.eml format files), so it's not an issue with data-entry.  Looks fine on SharePoint but either blank or just plain wrong in the exported Excel listing