Excel does strange things with my date data

Question

I want to convert my cells with a date from general to date. However, when I do this, some errors occur. Both just in my workbook as in my query editor.

Example, these cells have date in them but are marked as general:

And when I change it to date, it will change in this

And this is the exact content of the cells:

Date 1	Date 2
3/2/2022	12/20/2023
7/15/2022	12/18/2023
12/21/2021	12/15/2023
2/2/2022	12/15/2023
3/23/2022	12/14/2023
1/17/2022	12/14/2023
2/1/2022	12/13/2023
6/14/2021	12/12/2023
1/16/2022	12/11/2023
2/9/2022	12/8/2023

I tried forcing "/" into "-" with replace all, but this doesn't make a difference so far

EDIT: I changed format cells into this but that doesn't solve the problem: (if this is the correct way to do so)

Answer 1

In PQ, make sure you parse using locale and then you can specify the locale: