Convert them to real Excel dates as follows:
Select the single column of cells containing the dates (not the entire column of the whole sheet).
In the ribbon, go to the Data tab, and select Text to Columns in the Data Tools section
Choose delimited in the dialogue box, click Next, untick all the boxes, click Next, in Step 3 chose Date and select MDY in the dropdown, then click Finish.
Now your text dates are real dates.
Bookmarks