To sort dates in Excel, select a cell in your data, open Data > Sort, choose the date column, and select Oldest to Newest or Newest to Oldest. Sort the complete table or choose Expand the selection when prompted so each date stays with its row. Excel must recognize the entries as real dates, not text.
What You’ll Need
- An Excel workbook with a date column and any related information arranged in rows.
- Microsoft Excel for Microsoft 365 on Windows, as described below. The core sorting steps are similar in Excel for Mac and Excel for the web.
- For a safer sort, a header row that labels the date column and the other columns, such as Customer, Event, or Amount.
If the workbook contains important data, save a copy before sorting. Sorting can be undone immediately with Ctrl+Z on Windows or Command+Z on Mac, but a saved copy is useful if other edits happen afterward or the rows are accidentally rearranged.
Step-by-Step
- Check how the data is arranged. Each record should occupy one row, with dates in one column and the details for that date in the same row. For example, a schedule might have Date in column A, Appointment in column B, and Location in column C. Include a header row if possible. Avoid blank rows or blank columns inside the data because they can make Excel treat part of the list as a separate block.
- Check that Excel recognizes the dates. Select a few date cells and look at the formula bar. A real Excel date is stored as a number, even if the cell displays it as 3/14/2026 or March 14, 2026. Changing the number format may change how a real date looks, but does not change the underlying value. Text dates may appear left-aligned by default, while numbers and dates often appear right-aligned; alignment is only a clue, not proof. If the values are inconsistent, follow the text-date guidance in Troubleshooting before sorting.
- Select the data to sort. For an Excel Table, click any cell in the table. For an ordinary range, click a cell within the data, or select the full rectangle of headers and records. Including every related column is the safest choice. Do not select only the date cells if the other columns need to remain paired with them.
- Open the Sort dialog. On the Windows ribbon, select Data > Sort. If your range has headers, check that My data has headers is selected in the dialog. If the first row contains actual records rather than labels, clear that option so Excel does not exclude the first record from sorting.
- Choose the date column and sort order. In Sort by, choose the header for your date column, or its column name if the range has no headers. In Sort On, leave Cell Values selected. In Order, choose Oldest to Newest for chronological order from past to future, or Newest to Oldest to put the latest dates first. Select OK to apply the sort.
- Confirm that the complete records moved together. Check a few rows before and after sorting: each name, amount, or description should still match its original date. A sort changes row order; it should not rearrange values within a row. If Excel asks whether to expand the selection, choose Expand the selection, then select Sort. Choosing Continue with the current selection sorts just the selected cells and can mismatch the records.
- Sort from a date-column filter arrow when convenient. If the range has filter arrows, select the arrow in the date header and choose Sort Oldest to Newest or Sort Newest to Oldest. In a Table, this sorts the table records together. For a normal filtered range, make sure the filter covers the whole dataset, not just the date column. The Data > Sort dialog is preferable when you want to verify the sort field or add another level.
- Optionally add a second sort level. If several records have the same date and need a consistent order, use Data > Sort, select Add Level, and choose another column under Then by, such as Time or Last Name. Set the second order as needed and select OK. The first level remains the main chronological order; the next level only sorts records that tie on the first level.
On Excel for Mac, use the Data tab and its Sort controls; the dialog uses the same basic sort-by and order choices, though the ribbon layout can differ. In Excel for the web, select the range or click in a Table, then use Data > Sort ascending or Data > Sort descending, or use the filter arrow in the date header. Check that the entire range is included before sorting in any version.
Common Mistakes
- Sorting only the date cells. The dates move but names or other details stay in place, so the records become incorrect. Select the whole dataset or choose Expand the selection when Excel offers it.
- Sorting dates that are actually text. Text can sort alphabetically rather than chronologically. For example, text dates written as month/day/year may not follow calendar order because Excel is comparing characters rather than date values.
- Misidentifying the header row. If Excel treats a header as a record, it may move into the date list. If it treats the first record as a header, that record may be left out. Set My data has headers correctly in the Sort dialog.
- Sorting only part of a dataset. A blank row or column can cause Excel to identify a smaller region than you intended. Check the selected range in the Sort dialog and remove accidental gaps if appropriate.
- Expecting a date format to repair text. Choosing a date display format changes how numeric dates appear; it does not reliably convert text strings into real dates.
Tips
- Format the date column consistently, for example with a short date format, so unusual values are easier to spot. The displayed format does not determine chronological order once Excel recognizes the underlying dates.
- Convert a frequently sorted range into an Excel Table using Insert > Table. Confirm that the range includes all columns and that My table has headers is correct. Table filter arrows make sorting accessible, and sorting a Table keeps its records together.
- If dates include times, Excel sorts by the full date-and-time value. Two entries displayed as the same date can therefore appear in a particular order because their times differ. If you want dates to tie regardless of time, use a date-only field or make sure the display includes the time while checking the order.
- For repeatable multi-column sorting, use Data > Sort rather than sorting one column at a time. Set the date as the first level and any tie-breaker as a later level.
- Keep one date value per cell. A cell containing a range such as 3/14/2026–3/16/2026 is text, not two dates Excel can sort independently. Use separate start-date and end-date columns if you need to sort by either one.
Troubleshooting
The order looks alphabetical or otherwise wrong. The column may contain text dates, mixed formats, or values Excel cannot interpret. First make a copy of the data. For consistently formatted text dates, select the date cells and choose Data > Text to Columns. In the wizard, select Delimited and choose Next, leave the delimiters unchecked and choose Next, then select Date and the order that matches the source values, such as DMY, MDY, or YMD. Choose Finish. Check several converted dates before sorting; selecting the wrong order can change the meaning of ambiguous dates such as 04/05/2026. If the source strings use mixed formats, converting them may require cleaning the data first rather than applying one setting to the entire column.
Only one column moved. Undo immediately with Ctrl+Z on Windows or Command+Z on Mac. Then select the complete range and sort again, or use the Sort dialog and expand the selection if prompted. If undo is no longer available, restore the original file or reconstruct the records from a backup rather than assuming the rows still match.
The Sort command is disabled or the sort stops unexpectedly. Check whether the worksheet is protected; a protected sheet may prevent sorting unless the relevant permission is allowed. Also inspect the data for merged cells, which can interfere with sorting ranges. If needed, unprotect the sheet with the workbook owner’s permission, unmerge cells where appropriate, and try again. Do not remove protection if you are not authorized to change the sheet.
Some entries appear at the end or do not follow the rest. Blank cells, errors, and text mixed into a date column can be grouped separately from valid dates. Find and correct the outliers, or decide deliberately where blanks should remain. If dates include hidden times, display the time temporarily or inspect the underlying values to explain why same-day entries are ordered differently.
Excel sorts the wrong area. Undo, remove unintended blank rows or columns within the dataset, then select the full range again. In the Sort dialog, verify that the correct date header is listed under Sort by. If the range has separate blocks, sort each block only if they are truly independent; otherwise combine them into one continuous dataset first.
Frequently Asked Questions
How do I sort dates from newest to oldest?
Click a cell in the dataset, choose Data > Sort, set Sort by to the date column, and choose Newest to Oldest. Make sure all related columns are included so complete rows move together.
Why does Excel sort my dates incorrectly?
The entries may be stored as text, or Excel may be interpreting dates using a different day-month order than the source. Convert text dates using Data > Text to Columns and select the matching Date order, then verify the results before sorting.
Can I sort dates without moving the other columns?
You can sort only the date cells, but that usually breaks the relationship between each date and its record. To keep the information accurate, sort the complete rows. Sort a single date column only when it is genuinely independent of the rest of the sheet.
Can I sort by date and then by time?
Yes. Open Data > Sort, set the date field as the first level, choose Add Level, and set the time field as the second level. If the date cells already include both date and time values, Excel can sort by the full value in that column.
Can I sort dates in an Excel Table?
Yes. Select the arrow in the date-column header and choose Oldest to Newest or Newest to Oldest. Excel reorders the Table’s records together, including the other columns in each row.
Will sorting change the way my dates are displayed?
No. Sorting changes the order of the rows, not the date format. To change a date’s appearance, format the cells separately; the underlying date value remains what Excel uses for chronological sorting.
Related
- How to Rotate an Image in an Excel Cell: Steps and Tips
- How to Rotate an Excel Spreadsheet in Word: Easy Steps
- Rotate an Excel Table in Word: Step-by-Step Guide
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Reverse HLOOKUP: Formulas and Better AlternativesExcel has no separate “reverse HLOOKUP” function. If you mean looking up a value in one row and…
- Split Names in Excel: Text to Columns and FormulasTo split names into separate Excel cells, select the name column and choose Data > Text to Columns…
- Excel Row Number Formula Examples and UsesIn Excel, enter =ROW() to return the row number of the cell containing the formula; for example, in…
- Excel Column Letter to Number: Formula, Examples, and TipsTo convert an Excel column letter to its number, put the letter in A1 and enter =COLUMN(INDIRECT(UPPER(A1)&"1")) in…
- How to Clear an A to Z Filter in Excel and Show All RowsTo show all rows hidden by a filter in Excel for Microsoft 365 on Windows, open the filtered…
- How to Share an Outlook Calendar With the Right PermissionsTo share an Outlook calendar, open Calendar, choose Share Calendar, enter the recipient’s email address, set what they…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.