How to Sort Data in Excel by Date?

Select the range of data you want to sort

Go to the Data tab

Click Sort

Choose the column that contains the dates

Set Sort On to Cell Values

Choose the sort order: Oldest to Newest or Newest to Oldest

Click OK

If prompted, choose whether to expand the selection

Make sure the date column is formatted as a valid date

Use filters if you want to sort only a specific table or range

For multiple-level sorting, click Add Level and set additional sort criteria

Suggested for You

Trending Today