Can You Sort by Date in Google Sheets? Steps and Tips

Yes. In Google Sheets in a web browser, select your table and choose Data > Sort range > Advanced range sorting options, select the date column, and sort A to Z for oldest to newest or Z to A for newest to oldest. Include the full table in the selected range so each date stays with its corresponding row.

What sorting by date does

Sorting rearranges rows according to the values in a date column. An ascending sort puts earlier dates before later ones; a descending sort puts the most recent dates first. For example, a list containing 18 March, 4 January, and 9 February will appear as 4 January, 9 February, and 18 March when sorted oldest to newest.

Google Sheets does not usually sort real dates by the way their characters look. It sorts the underlying date values, which are stored as numbers, and displays them in the date format applied to the cells. This is why dates in different display styles can still sort in chronological order when Sheets recognizes them as dates.

The important distinction is between sorting a date column and sorting a whole dataset by that column. If a table has a date in column A, a customer in column B, and a status in column C, sort the complete A:C data range by column A. Sorting only column A can disconnect dates from the customers and statuses in the same rows.

Sort a range while keeping rows together

For a one-time sort, select the data range, including every column that belongs to each record. If the table has headings, include the heading row too, then use the advanced range sorting options to tell Sheets that the range has a header row. That keeps the headings at the top rather than treating them as a record.

Select the table range. For example, select A1:C20 if row 1 contains headings and rows 2 through 20 contain records.
Open Data > Sort range > Advanced range sorting options.
If the selection includes headings, check the option indicating that the data has a header row.
In the sort-by control, choose the column containing the dates.
Choose A to Z for oldest to newest, or Z to A for newest to oldest, then apply the sort.

For a range without headings, select only the data rows and leave the header-row option off. If you choose a quick sort command rather than the advanced dialog, check the selected range and sort column before confirming. The dialog is especially useful when the sheet has several columns or more than one sorting condition.

Sort an entire sheet or just a table

Sheets offers sorting for a selected range and for a sheet. These choices are not interchangeable. A range sort is generally the safer choice when the sheet contains multiple tables, notes, or unrelated information. Select only the table you want to reorder, including all its associated columns, and sort that range.

To sort a whole sheet by a column, click that column’s letter at the top, then choose Data > Sort sheet and the option for sorting by that column A to Z or Z to A. A whole-sheet sort moves the sheet’s rows according to that column, so it can also move material outside the table. Avoid it when separate information on the same sheet must remain in place.

When unsure, make a copy of the sheet or use a range sort. A copy is also a simple way to preserve the original order for reference. Sorting changes the row order in the selected data; it does not create a separate sorted view unless you use a filter view or a formula.

Sort with a filter or filter view

A filter adds dropdown controls to the header row. Select the table, choose Data > Create a filter, and use the dropdown in the date column to sort the displayed data A to Z or Z to A. The filter is handy when you want to sort and also temporarily show only records that meet conditions, such as dates in a particular month.

A filter view is useful when you want a saved view of the data without changing how other collaborators see it. Choose Data > Filter views to create a filter view, then sort or filter within that view. Availability and collaboration behavior can depend on access and the current Sheets interface, but the key distinction is that a filter view is designed to let someone work with a view of shared data rather than simply reordering the sheet for everyone.

Filters do not fix values that Sheets has mistaken for text. If dates sort into unexpected groups or an apparently chronological list looks wrong, first check whether the cells contain actual dates. A filter’s sort control uses the values in the column; it cannot reliably turn arbitrary text strings into dates just by sorting them.

Sort by more than one column

Multiple sort conditions help when many records share the same date. In Advanced range sorting options, choose the date as the primary sort, then add another sort column, such as a name or category. For instance, sorting by date ascending and then by customer name A to Z groups records chronologically and orders names within each date.

The order of the conditions matters. Sheets applies the first condition to the whole range; later conditions break ties among rows that match the earlier condition. If the date is first and the status second, status only determines the order of records with the same date. It does not put every record with the same status together across the entire list.

For a date column that includes times, the underlying values may include both the calendar date and a time of day. A cell formatted to display only the date can hide that time component. If two entries appear to have the same displayed date but sort separately, check their number format and underlying values. You may want to display the time or use an additional sort condition to make the order easier to interpret.

Use a formula for a separate, updating sort

If you want to preserve the source order and show a sorted copy elsewhere, the Google Sheets SORT function can return a sorted range. Put the formula in an empty area with enough room for the results to expand. The formula output is a view of the source data, not a replacement for sorting the original rows.

With headings in A1:C1, dates in A2:A20, and the other record fields in B2:C20, put this formula in an empty cell outside the source range to sort all three columns by the date in column A, oldest first: =SORT(A2:C20,1,TRUE). Here, 1 means the first column of the supplied range, and TRUE requests ascending order. Because the formula begins at row 2, it does not include the headings; add or retain headings separately above the results.

With the same A2:C20 layout, use this version to sort by date ascending and then by the second column of the range ascending: =SORT(A2:C20,1,TRUE,2,TRUE). The second sort condition only orders rows whose dates tie. If the source range changes in size, adjust the range in the formula; fixed ranges do not automatically include new records beyond their stated ending row.

Formula-based sorting is useful for reports and dashboards, but it has trade-offs. The displayed results update when source values change, while the source rows stay in their original order. You generally cannot edit an individual returned row as if it were an independent record; make changes in the source data instead. Also place the formula where its results will not overwrite other cells.

Why dates sometimes sort incorrectly

A common cause is that some entries are text rather than date values. Text may look like a date but sort alphabetically, producing an order that does not match the calendar. Mixed entries are especially confusing: recognized dates and unrecognized strings can sort in different ways, and formatting a text cell to look like a date does not necessarily convert its contents.

Check the source: Compare a few cells and see whether they were entered or imported in different formats. A leading apostrophe or inconsistent separators can indicate text.
Check the locale: Formats such as 03/04/2026 can mean different dates in different regional settings. Sheets uses locale-sensitive date interpretation, so confirm whether the intended date is March 4 or April 3.
Convert carefully: Re-enter dates using an unambiguous format or convert the text after confirming its meaning. Google Sheets has a DATEVALUE function, but the text it can interpret depends on the format and locale.
Check for blanks and errors: Decide how incomplete dates should be handled before sorting. Fill, filter, or review missing and invalid values rather than assuming they represent a meaningful date.
Check the selected range: Ensure the whole record is included and that the header row is identified correctly.

For an explicit conversion example, if A2 contains text that Sheets can interpret as a date, enter this in B2: =DATEVALUE(A2). Format the result as a date using Format > Number > Date, then fill the formula down as needed. Confirm the converted result against the original source, especially when dates use an ambiguous numeric format. Do not assume that conversion is correct merely because the result displays as a date.

Google Sheets and Excel sorting differences

The basic idea is similar in Google Sheets and Microsoft Excel: sort a complete data range by a date field, and keep each row’s values together. The menu paths differ. This article describes Google Sheets in a web browser, where the relevant controls are under Data. Excel uses its own ribbon sorting controls, so the Google Sheets menu names should not be followed in Excel.

In either program, a date-formatted appearance alone does not guarantee a cell contains a usable date value. Imported data, regional settings, and inconsistent text can create the same kind of sorting problem. If you move data between Sheets and Excel, verify date interpretation and formatting in the destination rather than assuming every displayed date will be understood identically.

Frequently Asked Questions

Can I sort dates from newest to oldest in Google Sheets?
Yes. Sort the full table by the date column and choose Z to A. The latest recognized date will come first.

How do I sort dates without moving the row information?
Select every column that belongs to the records, not just the date column, then sort the selected range by date. This keeps each row’s information together.

Why are my dates sorting alphabetically?
Some or all of the entries may be text rather than date values. Check the locale and source format, convert the values carefully, and verify the results before sorting again.

Can I sort by date and then by name?
Yes. In Advanced range sorting options, set the date as the first sort condition and add the name column as the second. The name condition orders records that have the same date.

Can Google Sheets sort dates automatically when new rows are added?
A manual sort does not automatically keep newly added rows in order. A SORT formula can display a separately sorted range that updates as included source values change, but you must make sure its range includes the new rows.

Does sorting change the date format?
No. Sorting changes row order, not the date’s number format. Use Format > Number to change how recognized dates are displayed.

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.