How to Sort Date Column with from Oldest to Newest

Please follow the steps below to sort a column with dates from oldest to newest, or check sorting dates from newest to oldest.

Step 1: Click any cell in the column you want to sort;

Step 2: Click the "Home" tab from the ribbon;

Step 3: Click "Sort&Filter" in the "Editing" section, and click "Sort Oldest to Newest" from the drop-down list;

Step 4: The date column and all other columns are now from Oldest to Newest.

Alternatively, please use right-click as below:

Step 1: Right-click the date column and select "Sort" from the list;

Step 2: Select "Sort Oldest to Newest".

Leave a Reply