How put in unique format date with different format dates in one column?

Question

I have data in a column with different formats, DD-MM-YYYY, MM-DD-YYYY, DD/MM/YYYY, MM/DD/YYYY, April-20. And I want to convert the dates in a unique format. Exist some function in Excel or a macro with VBA?

I'd tried with the function search and replace but there are more data in the datasheet.

Answer 1

Try using the "Text" function to convert back to a single format =TEXT(Your Cell,"DD/MM/YYYY") => Day / Month / Year =TEXT(Your Cell,"MM/DD/YYYY") => Month / Day / Year