Sort Dates in Excel – Easy Step-By-Step

How to sort dates in

Sorting dates is one of the most important tasks in any spreadsheet application. There are various methods to sort dates in Excel that are easy to use and quick to implement. In this tutorial, we will learn how to quickly sort dates.

Recommended read: How to use autosum in Excel?

How to Sort Dates in Excel?

Let us consider a dataset of a group of people with their date of birth:

Sort Dates in Excel

Follow these steps to sort the names according to their date of birth:

  • Select the cells containing dates.
Sort Dates in Excel
  • Click Sort & Filter in the Editing section on the Home tab.
sort filter option
  • From the Sort & Filter drop-down list, click on Sort Oldest to Newest or Sort Newest to Oldest.
Sort Dates in Excel
  • The Sort Warning dialog box will appear. Select the Expand the selection option and click Sort.
sort warning 1

The final result looks like this:

sorted dob

Changing the Date Format

To change the format in which the date is displayed before you sort, follow these steps:

  • Right-click on the cell which you want to format and select Format Cells from the list.
format cells option 3
  • In the Format Cells dialog box, go to the Number tab.
  • From the Category list, click on Date.
  • Select a format that best suits your purpose from the Type list and click OK.
format cells dialog 2


When dates in a worksheet aren’t in the order you want, you easily can sort them as discussed in this tutorial.