Question: how to change dmy to ymd in excel?
Answer: Select the column with the unrecognised dates, and go to Data tab, click Text to columns. Select Delimited, Next, Untick everything, Next, Select Date and from the dropdown select the order in which the dates currently are in your column. Hit Finish.