Try using "Text to columns"

Select column of dates

Data > text to columns > Next > Next > under "column data format" select "Date" and "DMY" > Finish