Sort Date – Dates (oldest to newest)

Sort Date – Dates (oldest to newest)

Select a column of dates or times in a range of cells, or make sure that the active cell is in a table column containing dates or times.

Select a column of dates or times in a range of cells or table.

On the Data tab, in the Sort & Filter group, do one of the following:

To sort from an earlier to a later date or time, click A to Z command in Excel that sorts A to Z or smallest number to largestSort Oldest to Newest.

To sort from a later to an earlier date or time, click Z to A command in Excel that sorts Z to A or largest number to smallestSort Newest to Oldest.

To reapply a sort after you change the data, click a cell in the range or table, and then on the Data tab, in the Sort & Filter group, click Reapply.