SharePoint list exported to Excel has different dates

%3CLINGO-SUB%20id%3D%22lingo-sub-2078461%22%20slang%3D%22en-US%22%3ESharePoint%20list%20exported%20to%20Excel%20has%20different%20dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2078461%22%20slang%3D%22en-US%22%3E%3CP%3EOne%20of%20our%20users%20has%20this%20problem%3A%3CBR%20%2F%3EThe%20dates%20appear%20correctly%20for%20her%20in%20the%20SharePoint%20list%2C%20but%20once%20she%20exports%20the%20list%20to%20excel%20as%20a%20query.iqy%2C%20the%20dates%20change.%3CBR%20%2F%3E%3CBR%20%2F%3EHere%20an%20example%3A%3CBR%20%2F%3E(SharePoint%20list%20view)%3CBR%20%2F%3EEntry%20A%3A%2025.03.2021%3CBR%20%2F%3EEntry%20B%3A%2020.01.2021%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E(Exported%20in%20excel%20view)%3CBR%20%2F%3EEntry%20A%3A%2026.03.2025%3CBR%20%2F%3EEntry%20B%3A%2021.01.2025%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2078461%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional 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

0 Replies