Power Query: data difference PQ screen vs Excel worksheet

Hi All,

I have data loaded from another file through PQ.
In the PQ screen my datums look correct (dd/mm/yyyy), but when all data is loaded to the worksheet the datums suddenly are 2027 (for 2023) and 2028 (for 2024) and the days are +1.
Can someone possibly explain what I'm doing wrong?

I'm grouping rows for that data*
Example:
Person Y has worked for Project 1 on 14/01/2024 for 4 hours.
Person Z has worked for Project 1 on 14/01/2024 for 4 hours.
PowerQuery groups those two rows to: Project 1 on 14/01/2024 = 8h

PQ screen - last step in process:
PQ screen.png

Worksheet:
Worksheet.png

Not from screenshots, no.

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

That's of no use - sorry. The source data is missing.

Please prepare a workbook that contains the following:

1. A worksheet containing the SOURCE data.
2. The query.
3. A worksheet containing the table generated by the query.