Question: how to change mdy to dmy?
Answer: there could be 2 scenarios; most simplest scenario is where he formatted the dates as MDY. simply select all the data, right click -> Format cells and change to DMY.