Hi,

I have to draw data til excel to assess status on accidents.
The data arrives from one source, but depending on who entered the data on the individual accident the date format is different (depending on whether they have an English or Danish Office 365 ).

In one row it is written as [4/27/2022 2:52pm] and in another it is written as [19-05-2022 14:22].
I cannot format the cells to a uniform date format, and I was told I could use IF/IFS to create a uniform date for further excel calculations, e.g. I need to know the number of dates between accident date and registration date.
This is not doable as the date format is not the same for the two cells.

Any ideas on how to solve this riddle?
Thank you in advance,
Louise