Sort dates in Excel

• Select the Date column which wants to be sorted

• Click on Data Tab in Ribbon Control and then click on Text To Columns.  

• In the first menu, select Delimited and click on Next.  

• In the second menu, select a delimiter, use Tab; then click on Next.  

• In the final menu, select Date and from the pull-down menu, select the date form currently used,  for example DMY; then click Finish. 

• Then click on sort & filter and click on Sort oldest to newest Or Sort Newest to Oldest

The column is sorted now