How to Sort by Date in Google Sheets (With Example)


The easiest way to sort by date in Google Sheets is to use the Sort range function within the Data tab.

The following step-by-step example shows how to use this function in practice.

Step 1: Enter the Data

First, let’s enter the following set of date values in Google Sheets:

Step 2: Verify that Data is in Date Format

If your data values are not in a date format, you won’t be able to sort them correctly.

To verify that the values are in a date format, make sure that all of the values are aligned to the right in the cell.

In the following screenshot, some of the values are left-aligned which means they’re not in a date format:

To convert each of the values in a column to a date format, simply highlight all of the values in the column and then click the Format tab, then click Number, then click Date.

Each of the values should now be right-aligned.

Step 3: Sort the Data

To sort the date values, highlight the range A2:A12 and then click the Data tab, then click Sort range, then click Sort range by column A (A to Z):

sort by date in Google Sheets

The dates will automatically be sorted from earliest to latest date:

If you instead click Sort range by column A (Z to A), the dates will be sorted from latest to earliest date:

Additional Resources

The following tutorials explain how to perform other common operations in Google Sheets:

How to Rank Items by Multiple Columns in Google Sheets
How to Use a RANK IF Formula in Google Sheets
How to Find the Top 10% of Values in Google Sheets

Leave a Reply

Your email address will not be published.