You need to change the format of the cells so that the Text values will be converted into Numeric values. After that, Excel will start recognizing dates. How to convert text date to mm dd yyyy in ...

In this article we will show you how to change date format in excel to dd/mm/yyyy, and also how to revert it to mm/dd/yyyy. Right-click on the cell with the date you want to convert into a number, and ...