Sort Data in Google Sheets by Date: Step-by-Step Guide

To sort data in Google Sheets by date, select the entire table, choose Data > Sort range > Advanced range sorting options, mark Data has header row if your table has headings, select the date column, and choose A to Z for oldest to newest or Z to A for newest to oldest. Sorting the whole range keeps each date with its related information. Before you begin, make sure the dates are recognized as dates rather than text.

What You’ll Need

A Google Sheets spreadsheet open in a web browser, with permission to edit it.
A table with one date column and the related information in adjacent columns, such as an event, customer, or payment record.
A clear header row, if your table has one. A heading such as Order Date makes it easier to identify the right sort column.

You do not need to install an add-on or use a formula for a normal date sort. If the spreadsheet is important, consider making a copy first. Sorting changes the order of rows, and undo may not be available if you make other changes afterward or close the file.

Step-by-Step

Check that each row is a complete record. Look across the table and confirm that the date and the information belonging to it occupy the same row. For example, an appointment date in column A should stay beside the matching name in column B and appointment type in column C. Do not sort only the date cells: that can leave dates paired with the wrong records.
Check the date column before sorting. Dates should be consistently entered and understood as dates by Sheets. A date can display as 3/4/2026, 04 Mar 2026, or another format while representing the same underlying date. Display format alone is not a problem. Mixed text and date values, however, can produce an unexpected order. If you suspect a problem, see the troubleshooting section below before sorting.
Select the complete data range. Click the first cell in the table, then drag to the last cell so the selection includes every column and every record you want to keep together. For example, if the table occupies A1 through D50, select A1:D50, not just the dates in column A. Include the header row if there is one; you will tell Sheets that it is a header in the next steps. If the table is very large, click its first cell and use the keyboard to extend the selection to the last row and column, checking that you have not included unrelated data.
Open the range-sorting controls. With the full range selected, go to Data > Sort range > Advanced range sorting options. Use the range option rather than sorting only the selected date column. The advanced dialog lets you choose the date field and indicate whether the first row contains column labels.
Identify the header row, if present. In the sorting dialog, check Data has header row when the first selected row contains labels such as Date, Name, or Amount. This keeps those labels out of the sort. Leave the option unchecked if the first row is an actual record. If your selection starts below the headings, do not include the heading row by mistake.
Choose the date column. In Sort by, select the heading for the date field, or the corresponding column if you did not select a header row. Check the column letter and the sample data in the range before proceeding. If two columns contain dates, make sure you select the one that answers your question, such as Due Date rather than Created Date.
Choose the order and apply it. Select A to Z for chronological order from earlier dates to later dates. Select Z to A for later dates to earlier dates. Click Sort. Sheets rearranges the selected rows as a unit, so information in the other selected columns should remain attached to its original date.
Review the result. Scan the first few and last few records to make sure the order is right. For A to Z, the earliest date should appear first; for Z to A, the latest should appear first. Also spot-check a name or other detail to confirm that its row moved with its date. If the order looks wrong, use Undo promptly with Ctrl+Z on Windows or Command+Z on Mac, then check the range and date values before trying again.

For a quick sort of a filtered table, you can instead use the sort control in the date column’s filter menu and choose Sort A to Z or Sort Z to A. This is useful when a filter is already applied. If you have not created a filter, the range-sorting steps above make it easier to confirm that the complete table and header are handled correctly.

Common Mistakes

Sorting only one column. This is the most damaging error because the dates can move without their related names or values. Select the complete rectangular table before sorting. If the data spans several columns, include all of them even if you only want to sort by one date field.
Leaving the header in the records. If the heading is treated as data, it may move into the body of the table. In Advanced range sorting options, check Data has header row when the first row in the selection contains labels. Conversely, do not check it when the selection begins with a real record.
Assuming a date-looking value is a date. Text such as 2026-04-03 may look like a date but can be stored as text, especially if it was pasted from another system or entered with a leading apostrophe. A column containing both true dates and text can sort in a way that appears inconsistent.
Choosing the wrong date field or direction. A table may have both Submitted Date and Visit Date. Verify the sort column before applying the order. Remember that A to Z means earliest to latest for actual dates, while Z to A means latest to earliest.
Selecting a partial table. A blank column or a second group of records can make it easy to miss part of the data. Check the selected range and include every row and column that belongs to the table. Avoid including unrelated notes or a separate table on the same sheet.

Tips

Use clear headings. Labels such as Invoice Date and Renewal Date are easier to distinguish in the Sort by menu than generic labels such as Date 1 and Date 2.
Keep the table continuous. A single header row followed by uninterrupted records is simpler to select and sort than a table broken up by blank rows, subtotals, or explanatory notes. Put notes outside the data range.
Set a consistent date display. Select the date cells and choose Format > Number > Date, or select a suitable date format from the number-format options. This changes how recognized dates display; it does not necessarily turn text values into real dates.
Sort by more than one field when useful. In Advanced range sorting options, use Add another sort column to set a secondary order. For example, sort by Appointment Date first and then by Last Name. The date remains the primary order, and the secondary field organizes records that share a date.
Use a filter for repeat sorting. Choose Data > Create a filter to add filter controls to the header row. The date column’s filter menu can then sort the table without reopening the advanced range dialog. Make sure the filter covers the full table and that the header row is correct.
Keep a clean source copy. If you need to preserve the original sequence, duplicate the sheet before sorting. This is helpful for imported lists or records where the original order has meaning, such as the order in which entries were received.

Troubleshooting

The dates appear out of order. First confirm that you selected the correct column and chose the intended direction. Then check whether some entries are stored as text. Click a suspicious cell and inspect its contents in the formula bar; pasted values with leading apostrophes or inconsistent formats deserve attention. Applying Format > Number > Date can make real dates display consistently, but formatting alone does not convert text into date values. Correct text entries by re-entering them as dates in a format that your spreadsheet locale recognizes. If values such as 4/5/2026 could mean either April 5 or May 4, confirm the intended interpretation before converting them.

The header moved into the data. Undo the sort immediately, select the table again, and open Data > Sort range > Advanced range sorting options. Check Data has header row if the first selected row contains headings. If it does not, ensure that your selected range starts with the first actual record rather than an unrelated title above the table.

Names no longer match their dates. Undo the operation if possible. The likely cause is sorting only the date column or leaving some related columns outside the selected range. Select the complete table and sort it again. Before applying the sort, verify the range includes all fields that belong to each record.

Some rows did not move. Check whether those rows fell outside your selection, were separated by blank rows, or belong to another table. Re-select the intended data range, including all records. If a filter is active, review whether rows are hidden by the filter; sorting a filtered range can make it appear that only visible records changed. Clear or adjust the filter if you need to review the full list.

Sheets will not let you sort, or the result cannot be edited. Check whether you have edit access and whether a protected range or sheet is restricting changes. Ask the owner for the required permission or an unprotected range. If a range contains merged cells, unmerge them before sorting where appropriate; merged cells can interfere with sorting because rows do not have a consistent shape.

The order changes when you edit dates. A normal sort does not automatically keep the sheet continuously sorted after later edits. Sort the range again when needed, or use a filter’s sort option. If the sheet is shared, let collaborators know before rearranging rows, because a sort changes the visible order for everyone with access.

Frequently Asked Questions

How do I sort dates from newest to oldest?
Select the complete table and choose Data > Sort range > Advanced range sorting options. Choose the date field and select Z to A. The latest recognized date should appear first.

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

Can I sort by date and keep the rest of each row together?
Yes. Select the full table, not just the date column, and sort the range by the date field. Sheets moves each selected row as a unit. Check the selected range before sorting so no related columns are left out.

Why does sorting treat some dates differently?
Some entries may be text rather than date values, or the spreadsheet may interpret ambiguous dates according to a different locale. Confirm what each ambiguous date means, then correct the entry so Sheets recognizes it consistently. A date display format by itself does not guarantee that a text value has been converted.

Can I sort dates when a filter is on?
Yes. Use the dropdown in the date column’s filter control and choose Sort A to Z or Sort Z to A. If the result seems incomplete, check whether the filter is hiding records and whether the filter includes the whole table.

Does changing the date format change the sort order?
Changing the display format usually changes only how a recognized date looks, not the date itself. The chronological sort should remain the same. If an entry is stored as text, format changes may not fix its value; convert or re-enter it as a date first.

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.