Do you know which files contain dates in which format? If you don't then this will be hard/impossible as is. Ideally you should be getting the dates in the same format. Failing that you need to deal with them separately, e.g. US format dates converted separately to UK dates.
Even if you tried something like
try Date.From([Dates] , "en-UK") otherwise Date.From([Dates] , "en-US")
it's not perfect because it can't tell if 07/04/2022 is April 7th or July 4th.
Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos. Blog
:: YouTube Channel
:: Connect on Linkedin
Proud to be a Super User!