How to sort by date in Google Sheets (4 methods)
Sorting by date is essential for schedules, timelines, activity logs, and any dataset with a temporal dimension. This guide covers 4 methods: basic Sort range, Advanced sort with headers, the SORT function (non-destructive), and Filter views — plus how to fix the #1 issue people run into (dates stored as text that won't sort correctly).
⚡ Quick Answer
Select your data range including headers, go to Data → Sort range → Advanced range sorting options. Check Data has header row, pick your date column, and choose A→Z (oldest first) or Z→A (newest first). Click Sort. All rows move together — not just the date column.
📋 4 methods in this guide
- Basic Sort range Fastest
- Advanced sort with header row Most reliable
- SORT function (non-destructive) Live sort
- Filter view sort Team-safe
Basic Sort range
Select your entire data range
Click and drag across all columns and rows. Include column headers. Critical: select all columns so entire rows sort together — not just the date column.
Open Sort range
Two quick options appear: sort by column A ascending or descending.
Choose direction
Sort range by column X (A→Z) — oldest dates first. Sort range by column X (Z→A) — newest dates first. Sheets uses the currently selected column as the sort key.
If your date column isn't column A, use Method 2 (Advanced) to pick it specifically.
Advanced sort with header row (recommended)
Handles headers automatically, lets you pick the exact sort column, and supports multi-column sorting. This is the method to use for anything more than a trivial sort.
Select your data
Include all rows AND columns. Include the header row (Sheets will handle it).
Open Advanced sort
Enable "Data has header row"
Check the box at the top. Now the sort column dropdown shows your column names (like "Order Date" instead of "Column B"). Prevents the header itself from being sorted with the data.
Pick your date column and direction
Select your date column from the dropdown. Choose A→Z (oldest first, ascending) or Z→A (newest first, descending). Click Sort.
Optional: add a second sort column
Click Add another sort column to break ties. Example: sort by date ascending, then by priority descending. Rows with the same date get sub-sorted by priority.
SORT function (non-destructive)
Returns sorted results to a new location without modifying source data. Perfect for dashboards that update automatically as source data changes.
Basic SORT syntax
Sorts range A2:C100 by column 2 (the date column in this example), ascending (TRUE means oldest first; FALSE means newest first).
Sort by date descending (newest first)
Sort with a filter condition
Filters for only "Open" items, then sorts them by date ascending. The two functions compose beautifully — see our ARRAYFORMULA guide for more patterns like this.
Multi-column sort with SORT
Sorts by column 2 ascending, then column 3 descending. Add more sort columns in pairs of (column, direction).
Filter view sort (team-safe)
Regular sorting rearranges data for everyone with access. Filter views are personal — you can sort by date without affecting how collaborators see the sheet.
Create a filter view
Sheets switches to a dark filter view mode with a name at the top.
Click the filter icon on your date column
Small funnel icon in the header row. Click it to open the filter panel.
Choose Sort A→Z or Z→A
At the top of the filter panel. Sorts within your filter view only. Other collaborators see the sheet in its original order.
Name and save the view
Type a name like "Sort by date ascending" in the top bar. It saves automatically. You can return to this view anytime from Data → Filter views.
Troubleshooting: dates that won't sort correctly
Symptom: "10/01/2026" appears before "2/01/2026" in your sort — because Sheets is treating them as text, not dates. Text sorts alphabetically (character by character), where "1" comes before "2".
Fix: Select your date column, then Format → Number → Date. If Sheets doesn't recognize the values, use DATEVALUE in a helper column: =DATEVALUE(A2). This returns a numeric date value that sorts correctly. Sort by the helper column, then hide it.
If some rows have "2026-09-03" and others have "September 3, 2026", Sheets may parse them inconsistently. Standardize the format first: select the whole column, apply a single date format via Format → Number → Date. If Sheets can't auto-parse, use QUERY with date parsing, or clean the data manually.
Caused by only selecting the date column instead of the entire data range. Undo with Ctrl+Z immediately. Reselect all columns (Ctrl+A within your data range works), then sort again.
Which method should you use?
| Scenario | Best method |
|---|---|
| One-time sort, quick | Method 1 — Basic Sort range |
| Multi-column tables with headers | Method 2 — Advanced sort |
| Dashboard that updates automatically | Method 3 — SORT function |
| Shared sheet where you don't want to move data | Method 4 — Filter view |
| Very large dataset (10k+ rows) | Method 3 — SORT function (avoids re-sorting overhead) |
Frequently asked questions
How do I sort by date in Google Sheets?
Select your data range including headers, go to Data → Sort range → Advanced range sorting options. Check "Data has header row", pick your date column, and choose A→Z (oldest first) or Z→A (newest first). Click Sort. Sheets rearranges all rows so the entire dataset moves together — not just the date column.
Why aren't my dates sorting correctly in Google Sheets?
The most common cause is that your dates are stored as text, not actual date values. Sheets sorts text alphabetically, so "10/01/2026" comes before "2/01/2026" incorrectly. Fix by selecting the column, then Format → Number → Date. If Sheets doesn't recognize them as dates, use DATEVALUE to convert: =DATEVALUE(A2) in a helper column, then sort by that helper column.
How do I sort by date without messing up other columns?
Always select the entire data range (all columns, all rows) before sorting — not just the date column. If you sort only the date column, only the dates move while other columns stay in their original order, breaking your rows. Data → Sort range with the whole dataset selected keeps rows intact.
Can I sort by date and then by another column?
Yes. In the Advanced sort dialog, click "Add another sort column" after selecting your date column. Choose the secondary column (like Priority or Category) and its direction. Sheets sorts primarily by date, then breaks ties using the secondary column.
How do I sort by date without modifying my original data?
Use the SORT function in a new location: =SORT(A2:C100, 2, TRUE) sorts range A2:C100 by column 2 (the date column) in ascending order. The original data stays untouched; sorted results appear where the formula is. Add FILTER for additional criteria: =SORT(FILTER(A2:C100, C2:C100="Open"), 2, TRUE) sorts only open items by date.