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

To sort data by date in Google Sheets, select the entire table, open Data > Sort range > Advanced range sorting options, identify whether the range has a header row, choose the date column, and sort A to Z for oldest to newest or Z to A for newest to oldest. Sorting the whole table range keeps each date attached to its corresponding row. Before you begin, make sure the dates are recognized as dates rather than plain text.

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 the rows of related information you want to keep together.
Permission to edit the spreadsheet. If the file is view-only or a protected range blocks changes, you will need appropriate access or an editable copy.

You do not need an add-on or a formula for ordinary date sorting. If you are sorting an important shared sheet, it is sensible to make a copy first or confirm that collaborators are not relying on the current row order. These instructions are for Google Sheets in a browser; Excel has different menus and sorting controls.

Step-by-Step

Check the date column and table boundaries. Identify the header row, the date column, and every other column containing information that belongs to the same records. For example, if column A contains dates, B contains names, and C contains amounts, those three columns must be sorted together. Look for blank rows or columns inside the table: they can make it harder to select the full set of records and may split the data into separate blocks.
Select the complete range of records. Click the first cell in the table, then drag to the last used cell so that the selection includes every column and row you want sorted. You can also click the first cell, hold Shift, and click the last cell. If the table covers A1:D50, select A1:D50, including the header row if there is one. Do not select only the date column; sorting that column by itself can pair dates with the wrong names, amounts, or notes.
Open the range-sorting controls. With the full range highlighted, choose Data > Sort range > Advanced range sorting options. A sorting dialog opens. If you do not see the expected controls, check that you selected cells in the table and that you have editing access. Google Sheets may also offer simpler sort commands in the Data menu, but the advanced range options make it easier to confirm the header setting and sorting column before applying the change.
Tell Sheets whether the selection has a header. If the first row contains labels such as Date, Customer, or Status, turn on Data has header row. This tells Sheets to treat that row as labels instead of as a record to sort. If your selection starts with actual data and has no header, leave the option off. Selecting the wrong setting can cause a header to move into the body of the table or cause a real record to be treated like a heading.
Choose the date column as the sort key. In the sort dialog, use the Sort by menu to select the date column. If you included a header and identified it correctly, the menu may show the header label; otherwise, it will show a column name such as Column A. Check the choice carefully, especially when the sheet has several date fields, such as Order Date, Due Date, and Payment Date. The selected field determines the order of the rows.
Choose the direction and apply the sort. Select A to Z to arrange dates from earliest to latest. Select Z to A to arrange them from latest to earliest. For example, an ascending sort places March 2 before March 18 and both before April 1 in the same year. Click Sort to apply the order. If dates include times, records on the same calendar day may also be ordered by time.
Verify the result and check related columns. Review the first and last few dates to confirm the direction, then spot-check a record you recognize to make sure its other values moved with it. If the table includes totals, notes, or formulas outside the selected range, confirm they still refer to the intended data. Use Edit > Undo immediately if the result is wrong, then repeat the sort with the full range and correct settings.

For a table you sort often, you can use a filter instead. Select the complete table, including the header row, and choose Data > Create a filter. A filter icon appears in each header. Click the icon in the date column and choose the ascending or descending sort option. Because the filter is created for a range, this is a convenient way to sort related rows together and repeat the operation later. Check that the filter covers all of the table before sorting.

You can also sort by more than one field when dates are tied. In the advanced range sorting options, use Add another sort column after choosing the date column. For example, sort by Date A to Z, then by Name A to Z. Sheets will order records by date first and use the second field to order records that have the same date. This is useful for schedules or logs where a stable, readable order matters.

Common Mistakes

Sorting only the date column. This separates dates from the rest of each record. Select the full table range, not just the cells containing dates.
Including unrelated rows or omitting data. A title, notes below the table, or a second table can be swept into the selection. Conversely, a column on the far right can be left behind. Confirm the selection outline reaches every row and column that belongs to the records.
Using the wrong header setting. If a heading is sorted as a date value, or a record is held out as a header, the output can look confusing. Check the first selected row before enabling the header option.
Assuming date formatting fixes text dates. Choosing a date display format changes how real date values look; it does not necessarily convert text that only resembles a date. Text values can sort alphabetically rather than chronologically.
Mixing date conventions. Values such as 03/04/2026 can mean March 4 or April 3, depending on locale. A column with inconsistent interpretations can produce a misleading order even when the sort itself works correctly.

Tips

Use an unambiguous date entry style. Enter dates consistently and check File > Settings for the spreadsheet locale when dates are being interpreted unexpectedly. A locale controls common date conventions and can affect how entered values are understood.
Format dates for readability after checking their values. Select the date cells and use Format > Number to choose a date display format. Formatting can make a column easier to scan, but confirm that the underlying cells are genuine dates before relying on a chronological sort.
Freeze the header for long lists. Choose View > Freeze and select the appropriate row option so column labels remain visible while you scroll. Freezing a row does not replace the header-row setting in the sort dialog.
Use filters for repeat work. A filter lets you sort from a column header without reopening the full range dialog. It can also help narrow a large list to particular dates or categories, while leaving the underlying records intact.
Keep a before-sort copy for sensitive data. For a sheet used by a team or for reporting, duplicate the tab or make a copy of the file before changing its order. Sorting changes row positions for everyone who sees that sheet, even though it does not delete the records.

Troubleshooting

The dates are in the wrong order. First confirm whether you chose A to Z or Z to A. Then inspect a few cells: a value that looks like a date may be stored as text, or the spreadsheet locale may interpret day and month in a different order. Select a suspect cell and check the formula bar and number formatting. If some entries align differently from the others, they may not share the same underlying date value.

Text dates need converting. If the values are consistently written as year-month-day text, you can convert one in a helper column and fill the formula down. With the text 2026-11-05 in A2, enter this in B2: =DATE(VALUE(LEFT(A2,4)),VALUE(MID(A2,6,2)),VALUE(RIGHT(A2,2))). It returns a real date for November 5, 2026. Format the helper cells as dates, verify several converted rows, then sort the full records using the helper column. This formula assumes the text is always exactly in YYYY-MM-DD order; do not use it unchanged for other date patterns.

Rows became mismatched or a heading moved. If the change just happened, choose Edit > Undo. Redo the operation by selecting the entire table, checking the header option, and sorting by the intended date field. If other people have edited the shared sheet since the sort, coordinate before undoing because undo can also reverse later changes.

Some rows did not move. Look for blank rows, merged cells, or data outside the selected range. Select the entire continuous table and check whether a filter is already active. Clear or adjust the filter if necessary, then verify that the range includes all records. If the sheet is protected, ask its owner for permission rather than trying to sort around the restriction.

The sort options are unavailable or a warning appears. Confirm that the file is open in Google Sheets and that your account can edit it. Protected ranges and certain merged-cell arrangements can prevent sorting. If the sheet contains merged cells within the data, unmerge them only if doing so is appropriate for the document, then retry. For an important file, preserve a copy before making structural changes.

Frequently Asked Questions

How do I sort dates from newest to oldest?
Select the full table, open Data > Sort range > Advanced range sorting options, select the date column, and choose Z to A. Include the header row correctly so the heading stays in place.

How do I sort dates from oldest to newest?
Use the same range-sorting process and select A to Z for the date column. This puts the earliest date first and the latest date last.

Can I sort by date without separating names or other details?
Yes. Select all columns and rows belonging to the records before sorting. Sheets then moves each selected row as a unit, keeping each date with its associated information.

Why does Google Sheets sort my dates alphabetically?
The cells may contain text instead of date values, or the entries may use inconsistent formats. Check the locale and the values, then convert text dates to real dates before sorting. Applying a date display format alone may not convert text.

Can I sort by date and then by another column?
Yes. In the advanced range sorting options, choose the date field first, then click Add another sort column and select a second field, such as a name. The second field breaks ties between rows with matching dates.

Will sorting change the sheet for other collaborators?
Yes. Sorting reorders cells in the shared sheet, so collaborators who view that sheet see the new order. Make a copy or coordinate with the team first if the current order is important.

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.