See all How-To Articles

Sort Dates in Chronological Order in Excel & Google Sheets

This tutorial demonstrates how to sort dates in chronological order in Excel and Google Sheets.

 

dates sorted chronologically 1a

 

Sort Dates in Chronological Order

By default, Excel stores dates as numbers, allowing them to be used in calculations. This also means it’s straightforward to sort dates in Excel.

Let’s use the following data set to walk through an example for sorting dates into chronological order.

 

sort dates initial data 1a

 

Here, you have dates in Column D, and you want to sort them from oldest to newest. To be able to sort dates, all cells in Column D need the same date format (here, M/D/YYYY). Later in this tutorial, you can find out how to format cells like this.

To sort dates, select any cell with a date in Column D and in the Ribbon, go to Home > Sort & Filter > Sort Oldest to Newest.

 

sort dates oldest to newest 1a

 

As a result, all dates in Column D are sorted in chronological order, from oldest to newest.

 

dates sorted chronologically 1a

 

Sort by Right-Clicking

Another way to achieve the same thing is by right-clicking.

Right-click any cell with a date in Column D and go to Sort > Sort Oldest to Newest.

 

right click sort dates 1a

 

The result is the same as above: Dates are sorted from oldest to newest.

Format Cells as Dates

Follow these steps to format numerical values in Column D as dates if they aren’t formatted that way already.

  1. To format values as dates (e.g., M/D/YYYY), first select all values in a column (range D3:D16 in this case) and in the Ribbon, go to Home, and click on the Number Format icon in the bottom right corner of the Number group.

 

format dates excel 1a

 

  1. In the Format Cells window, choose Date under Category.
    Then select 3/14/2012 (which represents M/D/YYYY), and click OK.

 

format dates excel 2

 

After this, all values in range D2:D15 are formatted as dates, and Excel recognizes them while sorting chronologically.

Also see: How to Convert String to Date With Text to Columns

Sort Dates in Chronological Order in Google Sheets

To sort dates from oldest to newest in Google Sheets, select all cells with dates in Column D (D2:D15). In the Menu, go to Data > Sort range by Column D, A → Z.

 

google sheets sort dates 1a

 

As a result, dates in the select range are sorted from oldest to newest.

 

google sheets dates sorted chronologically 1a

 

Sort Dates by Right-Clicking

Like in Excel, there’s also an option to sort dates in Google Sheets by right-clicking.

  1. Select the range with dates (D2:D15) and right-click anywhere in the selected range, then click on Sort range.

 

google sheets right click sort range 1a

 

  1. In the pop-up window, choose A → Z and click Sort.

 

google sheets right click sort range 2

 

The result is again the same: Dates in Column D are sorted chronologically.