How to Sort Dates in Google Sheets Without Mixing Rows

To sort dates in Google Sheets, select the full table, open Data > Sort range > Advanced range sorting options, choose the date column, and sort A to Z for oldest to newest or Z to A for newest to oldest. Include every column that belongs to each record so names, amounts, and other details move with their dates. Before sorting, make sure Sheets recognizes the entries as dates rather than plain text.

What You’ll Need

A Google Sheets file open in a web browser with permission to edit it.
A table with a date column and the related information you want to keep together.
A clear header row, if your table has column labels such as Date, Customer, or Amount.

If the dates were imported or pasted from another source, check a few cells first. Dates can look correct on screen while being stored as text, and text may sort alphabetically instead of chronologically. You do not need to install an add-on for ordinary sorting.

Step-by-Step

Check the date column. Click a date cell and look at how the value appears in the formula bar. If Sheets recognizes it as a date, changing its display format through Format > Number > Date will affect how it is shown. That menu is useful for choosing a consistent display, but formatting alone does not turn text into a date. If entries came from a file or website, first confirm that they follow a date pattern Sheets can interpret in your spreadsheet’s locale.
Identify the complete table. Decide which rows and columns make up the records you want sorted. For example, if each row contains a date in column A, a name in B, and a status in C, select all three columns for the rows containing those records—not just the dates. Include all associated fields, such as notes or invoice numbers, so they remain attached to the correct date. Avoid selecting entire unrelated columns if the sheet contains separate tables beside or below this one.
Select the range to sort. Click the first cell in the table, then drag to the final cell, or click the first cell and use Shift-click on the last cell. If the range is large, click its first cell and use the range box to enter a range such as A1:C50. Adjust the example to match your data. Include the header row if you have one; the next step tells Sheets to treat it as a header rather than a record.
Open the range sorting controls. With the full range selected, choose Data > Sort range > Advanced range sorting options. The advanced options let you identify a header row and choose the column that controls the order. If you select only one cell in a contiguous table, Sheets may offer to expand the selection to include nearby data. Check the proposed range carefully before proceeding, especially if another table is close by.
Tell Sheets whether the range has a header. In the sort options, select Data has header row if the first selected row contains labels such as Date or Name. Then choose the date column from the sort-by list. With the header option checked, the list should show the column’s label; without it, you may see a column letter or a first-row value. Do not mark the first row as a header if it is actually a dated record, or that record will be left out of the sort.
Choose the chronological direction. Select A to Z to place earlier dates first, which is the usual oldest-to-newest order. Select Z to A to place later dates first, or newest-to-oldest. Google Sheets uses these labels for sorting date values as well as text. Click Sort to apply the order. Review the first and last few records to confirm that the dates are in the direction you intended and that the other columns still match each date.
Sort by a second field if needed. If several rows share a date and you want a consistent order within each date, use the option to add another sort column in the advanced sorting dialog. Keep the date as the first sort field, then choose a secondary field such as Name or Time and set its direction. The date remains the primary order; the additional field only arranges records that have matching dates. This is useful for appointment lists or daily logs with multiple entries.

For a quick sort on an existing filter: If the table has a filter, open the filter icon in the date column’s header and choose the ascending or descending sort option. This sorts the filtered table while keeping each row together. A filter can also hide rows, so clear or review filter conditions if some dates seem to be missing. For an ordinary table without a filter, use the range-sorting steps above.

To sort a whole sheet: Use the sheet-sorting option in the Data menu only when the relevant records occupy the sheet and you want all of its rows reordered by one column. For most tables, sorting a selected range is safer because it reduces the chance of moving unrelated content elsewhere on the sheet. If you are unsure, make a copy of the sheet before sorting.

Common Mistakes

Selecting only the date column: Sorting a single column independently can separate dates from the names or values in the same records. Select the whole table or use its filter sort instead.
Including the header as a record: If the header is not identified as a header, it can move into the data. Check Data has header row when the selection starts with labels.
Assuming a date-shaped value is a real date: An entry such as 04/05/2025 can be ambiguous, and imported text may not be recognized. Locale settings affect how Sheets interprets date order, so check the dates before sorting.
Sorting a larger range than intended: A whole-sheet sort may rearrange blank rows, notes, or a second table. Select only the relevant table unless you deliberately want the entire sheet reordered.
Expecting dates with the same day to have a meaningful order: A date-only value does not include a time. If multiple records share a date, Sheets may leave their relative order unchanged unless you add a secondary sort field.

Tips

Use a consistent date display. After confirming that values are real dates, select the date cells and choose Format > Number > Date. A consistent format makes the column easier to scan, even though the displayed style does not determine chronological order.
Keep headers in the first row of the selected range. This makes the header-row setting straightforward and helps prevent labels from being sorted into the records.
Use a filter for repeated sorting. Choose Data > Create a filter with the table selected. The filter icons let you sort from the date-column header without reopening the advanced range dialog each time.
Check your spreadsheet locale when dates are ambiguous. Open File > Settings and review the Locale setting. It influences how date entries are interpreted and displayed. Changing it can affect date and number formatting across the spreadsheet, so check existing data before changing the setting.
Make a copy before a high-impact reordering. Sorting changes row order and can be undone immediately with the Undo button, but a copy is a useful safeguard if other edits happen afterward.

Troubleshooting

The dates are in the wrong order. First verify that you chose A to Z for oldest first or Z to A for newest first. Then inspect several cells that appear out of place. If they are text, inconsistent formats, or dates interpreted under the wrong locale, correct the underlying values before sorting again. Applying a date format changes appearance but will not, by itself, convert text values into real dates.

Some dates appear grouped oddly or sorted by the first digit. This often means some entries are text while others are recognized dates, or the column contains mixed formats. Check the source of the unusual entries and make them consistent. For ambiguous entries such as 03/04/2025, confirm whether the intended date is March 4 or April 3 before converting anything. If the data came from an import, use a small test copy to verify the corrected interpretation first.

Names or amounts no longer match the dates. Undo the sort immediately with the Undo button if the change was just made. Repeat the operation after selecting all columns in the table, or sort from a filter attached to the complete table. If other edits have occurred since the sort, compare with version history or a backup before trying to restore the original row relationships.

The header moved, or one row did not sort. Reopen the sort options and verify the selected range begins at the header and that Data has header row is checked. If the first row is data rather than labels, uncheck it. Also check that all intended records fall inside the selected range; sorting does not automatically include separated rows outside it.

Some records seem to have disappeared. Check whether a filter is hiding rows, and clear the filter conditions to show all records. Also look for blank rows or gaps that may have divided the table into separate ranges. Select the full continuous table and sort again once you have confirmed the records are present.

Frequently Asked Questions

How do I sort from newest to oldest?

Select the full table, open Data > Sort range > Advanced range sorting options, choose the date column, and select Z to A. Make sure the header-row setting matches your selection.

Can I sort dates without changing the rest of the row?

Yes. Include every column in the table when sorting, or use the sort option on a filter attached to the complete table. Do not sort the date cells by themselves if other cells in the row belong to them.

Why are my dates sorting alphabetically?

Some or all of the entries may be stored as text instead of date values. Check how they were imported, confirm the spreadsheet locale, and make the entries consistent. Changing the number format alone does not convert text into dates.

Can I sort by date and then by name?

Yes. In the advanced range sorting options, sort first by the date column, then add a second sort column for Name. The name order applies within groups that share the same date.

Will sorting a range change the original date values?

No. Sorting changes the order of the selected rows, not the date values themselves. It can still disrupt a table if you selected only one column, so include all related columns before applying the sort.

Is sorting different in Excel?

The basic idea is the same, but Excel has its own menus and controls. These instructions use Google Sheets in a web browser; follow Sheets’ Data menu paths rather than Excel ribbon directions.

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.