How to Sort by Date in Excel: 9 Suitable Methods

Method 1 – Applying Sort & Filter Feature to Sort by Date in Excel

Steps:

• Select the whole data set by selecting cells B4:D19.
• Go to the Home tab.
• From the Editing group >> select the Sort & Filter option.
• Select the Custom Sort option.

A Custom Sort dialogue box will appear.

• Under the Column option in Sort by, choose the column according to which you want to sort.

We choose Joining Date as we want to sort by date.

• Along with that, under the Sort On option, we choose Cell Values.
• Moreover, under the Order option, we choose Oldest to Newest.

This will sort the Date in ascending order. You can choose any order according to your preference.

• Click OK.

You will find the whole data set sorted according to the joining dates in ascending order.

Method 2 – Using SORT Function to Sort by Date in Excel

Steps:

• We will type the following formula in cell F4.

• Press ENTER.

We sorted according to the joining dates in ascending order.

Method 3 – Use of SORTBY Function to Sort by Date in Excel

Steps:

• Type the following formula in cell F5.

• Press ENTER.

The Employee IDs and Employee Names are sorted in ascending order, according to the Joining Dates.

Method 4 – Using SORTBY and MONTH Functions to Sort by Months

Steps:

• Type the following formula in cell F5.

• Press ENTER.

Find the data set sorted by the months of the joining dates of the employees in ascending order.

Method 5 – Applying SORTBY and DAY Functions to Sort by Day in Excel

Steps:

• Type the following formula in cell F5.

• Press ENTER.

You can see the result in cells F5:H19.

Method 6 – Using SORTBY and YEAR Functions to Sort by Years in Excel

Steps:

• Type the following formula in cell F5.

• Press ENTER.

Get the data set sorted according to the years in ascending order.

Method 7 – Using SORTBY, DAY, and MONTH Functions in Excel

Steps:

• Type the following formula in cell F5.

• Press ENTER.

Get the data set sorted by the ascending birthdays.

Method 8 – Applying INDEX, MATCH, ROW, and RANK Functions

In this method, we will use the combination of the INDEX, MATCH, ROW, and RANK functions to sort by date in Excel. This method is helpful if you do not have an Office 365 subscription,

The first data set, but a new column Salary has been inserted between the Employee Name and Joining Date.

If we want to sort not all the columns, only the Employee ID, Employee Name, and Joining Date, according to the Joining Date?

You can not execute this using the SORT or SORTBY function of Excel.

Using the SORT and SORTBY functions, you can only sort the adjacent columns, not the non-adjacent ones.

That means you can sort the Employee Name, Salary, and Joining Date. Or, the Employee ID, Employee Name, and Salary. Or, the Name and Salary.

But not the Employee ID, Employee Name, and Joining Date.

You can use a combination of the INDEX, MATCH, ROW, and RANK functions of Excel to sort the columns that are not adjacent.

• To sort Employee ID, Employee Name, and Joining Date according to the Joining Date, in ascending order,  we will type the following formula in cell G5.

[This is an Array Formula. So do not forget to press CTRL+SHIFT+ENTER unless you are in Office 365.]

• Press ENTER.

You will find the Employee ID, Employee Name, and Joining Date sorted in ascending order, according to the Joining Date.

Method 9 – Applying VBA to Sort by Date in Excel

Steps:

• Press ALT+F11 to bring out the VBA editor window.

At this moment, a VBA editor window will appear.

• Double-click on Sheet11 (VBA).

• Type the following code in the editor window.

Private Sub Worksheet_Change(ByVal Target As Range)
   On Error Resume Next
   Range("B4").Sort Key1:=Range("D5"), _
     Order1:=xlAscending, Header:=xlYes, _
     OrderCustom:=1, MatchCase:=False, _
     Orientation:=xlTopToBottom
End Sub

We close the VBA editor window and go back to our worksheet.

See that the dataset has been sorted by date.

Download Practice Workbook

You can download the Excel file from the link below and practice while reading this article.

How to Sort by Date in Excel: Knowledge Hub

<< Go Back to Sort in Excel | Learn Excel