How to Sort by Date in Google Sheets

To sort dates in Google Sheets, select the entire table, choose Data > Sort range > Advanced range sorting options, select the date column, and choose A to Z for oldest to newest or Z to A for newest to oldest. If your table has a header row, check the option indicating that the data has a header row before sorting.

Sort a table by date: step by step

In Google Sheets in a web browser, sorting a date column reorders rows according to their date values. The key is to select the full table, not just the dates, so each date stays attached to the name, status, amount, or other information in its row.

Click and drag to select the table, including all columns that belong together. If the sheet contains only one table, you can click a cell inside it and use the range options in the Data menu, but selecting the full table makes the intended data boundary clear.
Choose Data > Sort range > Advanced range sorting options.
If the first row contains column labels such as Date, Customer, or Status, check Data has header row.
Under Sort by, choose the column containing the dates. Choose A to Z for chronological order, from earliest to latest, or Z to A for reverse chronological order, from latest to earliest.
Click Sort. Check a few rows afterward to confirm that the dates and their related information moved together.

For example, sorting a meeting log by its Date column from A to Z puts a January 8 meeting before a January 19 meeting, then before a February 2 meeting. Choose Z to A if you want the newest meeting at the top. The A-to-Z and Z-to-A labels are used for dates as well as text; they do not mean that the dates are being treated as words.

Sort the whole sheet or only a selected range?

Google Sheets offers sorting for a range and for a sheet. Sort range is usually right for a table that shares the sheet with notes, a summary, or another separate block of data. Select the table first so the sort applies to its rows and columns rather than to unrelated cells.

A sheet-level sort is useful when the relevant records occupy the sheet and you want their rows reordered together. From the Data menu, use the sheet-sorting option and choose the date column and direction. Be cautious if the same sheet contains other data: a sheet-level sort can move rows beyond the table you had in mind. Before sorting, check whether there are separate lists, totals, or explanatory notes elsewhere on the sheet.

Do not select just the date cells and sort them by themselves when other columns describe those dates. That can leave the dates in a new order while names or amounts remain in their old rows, effectively changing which date belongs to which record. If Sheets detects adjacent data, it may offer to expand the selection; choose the option that includes the complete table when those cells are part of the same records.

Keep headers and sort by a second column

A header such as Date is a label, not a record. In the advanced range sorting options, mark Data has header row so Sheets sorts the records without placing the header among the dates. If that setting is missed, the label can be moved into the data or included in the sort, making the result harder to read. If you use a sheet-level sort, verify that the header is recognized or excluded as appropriate.

You can also sort by more than one column. In Advanced range sorting options, choose the date column as the first sort key, then add another sort column. For instance, an appointment list can be sorted by Date first and by Start time second, so entries on the same date are grouped by time. A sales log could use Date as the first key and Rep as the second to group same-day records by salesperson. The first key determines the main order; later keys only organize rows whose earlier sort values match.

When dates include times, a date sort may already order entries on the same day by time, because the underlying values can contain both a date and a time. A second time key is most useful when the date column contains date-only values or when you want a separate, explicit rule for ties. If the displayed dates look identical, inspect the cells or their number format before concluding that the sort did nothing.

Sort dates with a filter

For a table you will sort repeatedly, a filter provides a quick way to change the order. Select the table, choose Data > Create a filter, and use the filter control in the Date column header. The menu offers sorting options such as Sort A to Z and Sort Z to A. The filter keeps the header controls available, and it can also let you show or hide records based on conditions.

A filter is particularly handy when you need to inspect a subset of records, such as appointments in one month, without deleting the rest of the data. Sorting the filtered table changes the order of the visible records while rows remain part of the underlying data. Take care when collaborating: other people may be affected by a regular filter or its sort. If you need a separate view of the data, Google Sheets also provides filter views from the Data menu; a filter view is designed to let someone arrange or filter data without changing the view for everyone else.

Sorting does not remove records. A filter can hide rows that do not meet its conditions, which may make it seem as though a sort has lost data. Clear the filter or review its conditions if expected dates are not visible.

Make sure Sheets recognizes the values as dates

The most common reason a date sort looks wrong is that some entries are stored as text rather than as date values. Sheets can sort actual dates chronologically, but text that looks like a date may be ordered alphabetically or grouped separately. For example, text entries beginning with 1 can appear together regardless of the month or year they are meant to represent.

Click a suspicious cell and inspect its contents in the formula bar. Also try changing the display format through Format > Number > Date. A date format controls how a value is displayed; applying it does not reliably turn every text string into a real date. If the cell remains left-aligned or refuses to display as a date, it may still be text, although alignment alone is not a definitive test.

For text dates in a consistent format that Sheets can interpret, you can convert a sample in a helper column. With a text date in A2, enter =DATEVALUE(A2) in B2 and fill the formula down. DATEVALUE returns a date value when the text is recognized; the way an ambiguous string such as 3/4/2026 is interpreted depends on the spreadsheet’s locale. Check the converted results before relying on them, and use the correct locale under File > Settings if the sheet’s date conventions differ. Once the values are correct, you can use the helper column to sort and, if needed, copy the converted results and paste values over the original data.

To change how valid dates appear, select the cells and choose Format > Number > Date. The visible style may differ from the underlying value: a date can display as Mar 4, 2026 or 3/4/2026 and still sort correctly. Locale settings affect date interpretation and formatting, so teams sharing a sheet should agree on a clear date convention, especially when importing data from different regions.

Fix dates that sort incorrectly

If the order still seems wrong, check these common causes before repeating the sort:

Some dates are text: Convert or re-enter the text as recognized dates, then sort again. Mixed real dates and text values are a frequent cause of unexpected groups.
The wrong column was selected: In the sort options, verify the chosen column and confirm that the table’s rows are included.
The header was treated as data: Mark the header-row option or exclude the header from the selected range.
The date format is ambiguous: Review File > Settings > Locale and confirm that entries such as 04/05/2026 mean what you intend.
Time values are hidden: Cells may contain different times on the same displayed date. Use a date-time display format or inspect the underlying values if same-day records appear in an unexpected order.
Blank or incomplete cells are present: Check whether empty cells or notes interrupt the table and whether they are included in the selected range.

Sorting also changes row order, which may affect formulas or references that rely on a particular layout. Formulas that refer to the same records generally remain associated with their cells, but review any summaries, manually numbered lists, or instructions that assume records are in a fixed position. If the data is important, make a copy of the sheet or use version history before making a large reorganization.

Use the SORT formula for a separate ordered view

If you want an automatically sorted copy while leaving the source table untouched, use the Google Sheets SORT function. With dates in column A and related fields in columns B through D, and records in rows 2 through 20, enter =SORT(A2:D20, 1, TRUE) in an empty area. This returns the range ordered by its first column, from earliest to latest. Change TRUE to FALSE for newest to oldest.

The formula result expands into neighboring cells, so leave enough empty space for all returned rows and columns. It is a view of the source data, not a replacement for sorting the original table; changes to the source can change the displayed result. If you see an expansion error, check for existing content in the cells where the results need to appear. For a different date column within the selected range, change the second argument to that column’s position within the range. For example, if the date is the third column of the selected range, use 3 rather than 1.

A formula-based view is useful for dashboards or reports where the original entry order should stay intact. For a one-time reordering of the existing records, the Data menu sort is simpler. The formula method also makes the sort rule visible in the sheet, which can help explain why a displayed list changes when source data is edited.

How Google Sheets differs from Excel

The basic idea is similar in Excel: sort the full record range by its date column and choose ascending or descending order. The menus and dialog labels differ, however. The steps above use Google Sheets in a web browser, including its Data menu and range-sorting options; Excel has its own Sort controls and dialog, so its exact menu path should not be assumed to match Sheets.

Both programs need recognizable date values to sort chronologically. In either one, formatting a cell changes its display but does not necessarily repair text that only resembles a date. If you move a workbook between Excel and Sheets, verify the date interpretation, locale-dependent formats, and formulas after import or export. A value displayed in a familiar date style is not by itself proof that every cell in the column has the same underlying type.

Frequently Asked Questions

How do I sort Google Sheets by date 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. If the table has headers, mark Data has header row.

Why is Google Sheets sorting my dates alphabetically?
At least some entries may be text rather than date values. Check the cells, confirm the spreadsheet locale, and convert consistently formatted text dates into actual date values before sorting.

Can I sort by date without moving the other columns?
Not if the other columns contain details belonging to each date. Sort the complete table so each record stays together. Sorting only the date cells can disconnect dates from their associated information.

How do I sort dates while keeping the header at the top?
Use the advanced range sorting options and enable Data has header row. You can also select only the data rows, leaving the header outside the range, but check that all record columns are included.

Can Google Sheets automatically keep dates sorted?
A normal menu sort rearranges the current data; it does not promise to reposition each new entry automatically. For a live, separate ordered display, use SORT with the source range and leave room for the formula results to expand.

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.