How to Sort Dates in Google Sheets: A Step-by-Step Guide

To sort dates in Google Sheets, select the whole table, choose Data > Sort range > Advanced range sorting options, identify any header row, then sort by the date column from A to Z for oldest to newest or Z to A for newest to oldest. Before sorting, check that Sheets recognizes the entries as dates; otherwise, text that looks like a date may not fall into chronological order.

Sorting makes timelines, schedules, transactions, and other date-based lists easier to scan. The key is to sort complete rows together, so each date stays attached to its corresponding name, amount, status, or other details.

What You’ll Need

A Google account and a spreadsheet open in Google Sheets in a web browser.
A table with a date column and, if applicable, a header row.
Edit access to the sheet. If the range is protected or you only have view access, you may not be able to sort it.

Step-by-Step

Check the table layout. Make sure the dates and their related information form a continuous table, with one record per row and column headings in the top row if you use headings. Look for blank rows or columns inside the table; they can cause Sheets to detect only part of the data. If the table has a title above it, do not include that title in the range you sort.
Confirm that the dates are actual date values. Click a date cell and inspect the formula bar. A date value may display in several formats, but Sheets should treat it as a date rather than as a text label. To apply a consistent appearance, select the date cells and choose Format > Number > Date. This changes how recognized dates display; applying a date format does not necessarily convert text that only looks like a date.
Select the complete data range. Drag across all the columns and rows that belong to the table, including the date column and every detail that should stay with each record. For example, for headings in A1 through C1 and data through row 25, select A1:C25. Include the header row if there is one, but exclude unrelated notes or totals below the list.
Open the range-sorting options. With the range selected, choose Data > Sort range > Advanced range sorting options. Use the advanced options when you need to specify a header row or sort by a named column. If Sheets offers a simple sort command for the selected range, the advanced option gives you more control over which column is used.
Tell Sheets whether the range has a header. In the sort options, check Data has header row if the first row contains labels such as Date, Customer, or Amount. Leave it unchecked if the first row is already a record. This helps Sheets show column names instead of treating a heading as a date entry.
Choose the date column and direction. Under Sort by, select the date heading or the corresponding column. Choose A to Z for chronological order from earliest to latest. Choose Z to A for latest to earliest. Click Sort to apply the order to the selected range.
Check the result before continuing. Confirm that the dates run in the direction you wanted and that details in every row still match the correct date. If the first row is a heading, make sure it remains at the top. If the order looks wrong, use Undo immediately or repeat the sort after checking the date values and selected range.

For a quick sort when the range is straightforward, select a cell in the date column and choose Data > Sort sheet > Sort sheet by column A (A to Z) or the corresponding column and direction shown in the menu. This sorts the sheet by that column, rather than limiting the action to a selected table range. Check that the sheet has a header and that unrelated content will not be affected before using this option.

You can also create a filter for a table: select its range, choose Data > Create a filter, then use the filter icon in the date-column header to sort A to Z or Z to A. The filter controls are useful when you want to sort or temporarily narrow the visible records using column values. To remove the filter, choose Data > Remove filter.

Common Mistakes

Sorting only the date column. If you select just the dates and sort those cells, names or other details in neighboring columns may stay in place. Select the full table or use a filter on the table so each record remains intact.
Choosing the wrong direction. A to Z means earliest to latest for dates; Z to A means latest to earliest. Check the first and last date after sorting rather than relying on the letter labels alone.
Including a heading as a record. If the header-row option is not set correctly, a label such as Date may be included in the sort. Conversely, marking a range as having headers when its first row is a real record can leave that record unsorted.
Assuming date formatting fixes text dates. Changing a cell’s number format affects the display of recognized values. It does not always convert entries imported as plain text, so a date-looking string can still sort alphabetically.
Leaving out part of the table. Sorting only some rows or columns can split records apart or leave a section behind. Check the selection outline and include all records that belong together.
Sorting a sheet that contains other content. Sort sheet commands affect the sheet based on a column. If there are separate lists or notes on the same sheet, use a selected range or a filter on the intended table instead.

Tips

Use a consistent date format. A display such as 3 Nov 2026 can make a list easier to read and reduce confusion between formats such as 04/05/2026. Choose a format that matches the way your dates are entered and understood.
Keep one date type in each date column. Avoid mixing dates, labels such as Pending, and explanatory notes in the same column. Store notes in a separate column so chronological sorting stays predictable.
Sort by more than one field when needed. In the advanced range-sorting options, use Add another sort column to set a secondary order. For instance, sort first by date and then by name to arrange records with matching dates consistently.
Use filters for a list you revisit. A filter lets you sort using the column header and can make a working table easier to manage without repeatedly selecting its full range. Keep headers clear so the filter icons are easy to identify.
Consider time values. If cells contain both a date and a time, sorting by that column can order entries by the full date-and-time value. If you only need day-level order, make sure the stored values and display format suit that purpose.
Check the spreadsheet locale for imported dates. In Google Sheets, choose File > Settings to view the spreadsheet locale. The locale can affect how ambiguous date entries are interpreted, such as whether a slash-separated value is read as month/day or day/month.

Troubleshooting

The dates sort alphabetically or appear out of order. Some entries may be stored as text, or the column may mix real dates with text. Check a few cells, re-enter a problematic value as a date, or convert the source data to a consistent date format. If dates came from a CSV or another system, check the locale and the source format before importing again. Reapplying Format > Number > Date alone may not correct text values.

Dates like 04/05 appear to have switched meaning. The entry is ambiguous: it could mean April 5 or 4 May. Check the original source and the spreadsheet locale under File > Settings. Do not assume the displayed order tells you which interpretation was intended. Correct ambiguous values using the confirmed meaning, then sort again.

Rows have become mismatched. Undo the sort straight away with Edit > Undo or Ctrl+Z on Windows and ChromeOS (Command+Z on Mac). Then select the entire table and repeat the sort. If the sort has already been followed by other edits, inspect the records carefully before trying to repair them; undoing multiple actions may also reverse those later edits.

The heading moved into the list. Repeat the sort and set Data has header row correctly. If you are using a filter, make sure the selected range includes the actual heading row before choosing Data > Create a filter.

The sort command is unavailable or does nothing. Confirm that you have edit permission, that the right range is selected, and that the cells are not in a protected range. If a filter or filter view is active, check that you are working within its intended range. You can also reload the browser tab if the sheet appears not to respond, after making sure any changes have been saved.

Only some of the records moved. Look for blank rows or columns that may have divided the table, or for rows outside the selected range. Select the full set of records again. For recurring work, a filter on the complete table can help keep sorting within the intended data area.

Frequently Asked Questions

Does A to Z mean oldest to newest in Google Sheets?
Yes. For recognized date values, A to Z sorts from earliest to latest. Z to A sorts from latest to earliest.

Can I sort dates without moving the other columns?
You can, but it is usually a mistake for a table: the dates may no longer match their original records. To keep each record together, select the full table or use its filter controls.

Why does Google Sheets put some dates in the wrong place?
The cells may contain text instead of date values, use inconsistent formats, or have been interpreted using a different locale. Check the underlying entries and the spreadsheet locale, then correct the data before sorting again.

How do I sort dates and then sort matching dates by name?
Open Data > Sort range > Advanced range sorting options, choose the date column and direction, then select Add another sort column and choose the name column and its direction.

Will sorting change the dates themselves?
A normal sort rearranges rows; it does not change the date values. However, sorting only one column can detach dates from the related details, so sort the whole table.

Is sorting in Excel the same?
The idea is the same, but the menus differ. In Excel for Microsoft 365 on Windows, use the Data tab’s Sort command for a sort dialog; these Google Sheets menu paths apply to Sheets in a browser.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.