How to Sort by Date in Google Sheets (Easy Guide)

Knowing how to sort by date in Google Sheets makes it much easier to manage deadlines, invoices, appointments, or any kind of schedule, since everything stays in chronological order and easy to scan. This guide walks you through every method, from the simplest built-in sort to formulas and filters, so you can pick whatever works best for your spreadsheet.

Before You Start: Make Sure Your Dates Are Formatted Correctly

Google Sheets can only sort dates properly if it recognizes them as dates — not as plain text. This is the number one reason sorting goes wrong.

Quick check: Click a cell with a date in it. If the value shows up right-aligned in the cell, it’s a real date. If it’s left-aligned, Sheets is treating it as text.

To fix text-formatted dates:

Select the column with your dates.
Go to Format > Number > Date.
Sheets will convert the values into a recognized date format.

If some entries still won’t convert, check for inconsistent formats (like mixing “07/23/2026” with “July 23, 2026”) in the same column — this confuses Sheets and can cause incorrect sorting.

Method 1: How to Sort by Date in Google Sheets Using the Data Menu

This is the fastest way to sort an entire sheet by a date column.

Click any cell in your dataset.
Go to Data in the top menu.
Select Sort sheet by column [X], A to Z (oldest to newest) or Z to A (newest to oldest).

If your data has headers, Google Sheets usually detects them automatically and keeps the header row locked in place while sorting everything else.

Method 2: Sort a Specific Range (Not the Whole Sheet)

Sometimes you only want to sort part of your data, not everything on the page.

Highlight the range of cells you want to sort, including the date column.
Go to Data > Sort range.
Check the box for Data has header row if applicable.
Choose the column with your dates and select A → Z (Oldest first) or Z → A (Newest first).
Click Sort.

How to sort by date in Google Sheets Specific Range

This method is useful when you have multiple tables on one sheet and don’t want to disturb the rest of your layout.

Method 3: Use the Filter Tool to Sort by Date

If you already have filters turned on (or want quick sorting without permanently reordering rows), this is a great option.

Select your data range and click Data > Create a filter.
Click the filter icon in the header of your date column.
Choose Sort A → Z (earliest to latest) or Sort Z → A (latest to earliest).

Filters are handy because you can toggle sorting on and off without losing your original row order.

Method 4: Sort by Date with the SORT Function

If you want a dynamic list that automatically reorders itself as new dates are added, use the SORT function. This is one of the most useful Google Sheets sort functions because it doesn’t touch your original data — it builds a live, sorted copy wherever you place the formula.

Basic syntax:

SORT(range, sort_column, is_ascending, [sort_column2, is_ascending2, ...])

Example:

=SORT(A2:C100, 1, TRUE)

A2:C100 is your data range.
1 tells Sheets to sort by the first column in that range (adjust the number if your date column isn’t first — for example, use 2 if dates are in the second column).
TRUE sorts oldest to newest; use FALSE for newest to oldest.

Sorting by multiple columns: You can also sort by more than one column at once. For example, to sort first by date and then alphabetically by name within each date:

=SORT(A2:C100, 1, TRUE, 2, TRUE)

This tells Sheets to sort by column 1 (date) first, then break ties using column 2 (name), both in ascending order.

Because SORT is a formula, it recalculates automatically whenever your source data changes — making it ideal for dashboards, reports, or any sheet pulling from a master data source.

Bonus: Sort by Date Using QUERY and ORDER BY

If you’re already comfortable with the QUERY function, you can sort by date using its ORDER BY clause. This is especially useful when you’re combining sorting with filtering, since QUERY can do both in a single formula.

=QUERY(A2:C100, "SELECT A, B, C ORDER BY A ASC", 1)

A2:C100 is your data range.
"SELECT A, B, C ORDER BY A ASC" tells Sheets to return all three columns, sorted by column A (your date column) in ascending order. Swap ASC for DESC to sort newest to oldest.
The final 1 tells Sheets how many header rows to expect.

You can also add filtering conditions directly into the same formula, for example only showing rows from the current year:

=QUERY(A2:C100, "SELECT A, B, C WHERE A >= date '2026-01-01' ORDER BY A DESC", 1)

How to Sort in Google Sheets using ORDER function

QUERY takes a bit more practice than SORT, but it’s powerful once you’re comfortable pulling filtered, sorted data straight from a formula.

Common Problems and How to Fix Them

Dates aren’t sorting correctly This almost always means some values are stored as text. Reformat the column using Format > Number > Date and check for typos or inconsistent formats.

Some rows didn’t move when I sorted Make sure you selected the entire range, including all relevant columns, before sorting. If you only select the date column, Sheets will reorder just that column and leave the rest of your row data mismatched.

I want to sort by month or day only, ignoring the year Use a helper column with a formula like =MONTH(A2) or =DAY(A2) and sort by that column instead.

Frequently Asked Questions

Can you sort by date in Google Sheets? Yes. If you’re wondering how to sort by date in Google Sheets, the short answer is: use the built-in Data menu, the Sort range tool, filters, or formulas like SORT and QUERY. As long as your dates are formatted as actual dates (not text), sorting takes just a few clicks.

How do I sort a column by date without messing up the rest of my data? Always select the full range of columns you want sorted, not just the date column. Using Data > Sort range with “Data has header row” checked keeps every row’s data aligned correctly while sorting.

Why won’t Google Sheets sort my dates correctly? This usually happens when dates are stored as text instead of actual date values, or when a column mixes multiple date formats. Reformat the column with Format > Number > Date to fix it.

Final Thoughts

Now that you know how to sort by date in Google Sheets, keeping any schedule, deadline tracker, or invoice log in order is simple once your dates are properly formatted. For a one-time sort, the Data > Sort sheet or Sort range options will get the job done in seconds. If you want your sheet to stay automatically organized, the SORT formula is the way to go. Either way, a few clicks are all it takes to turn a messy spreadsheet into a clean, chronological list.