Date Sort in Excel: Steps, Fixes, and Sorting Tips

Formulas & functions · Updated November 22, 2026

To sort dates in Excel, select a cell in the date column, open the Data tab, and choose Sort Oldest to Newest or Sort Newest to Oldest. Excel will arrange real date values chronologically; if the result looks wrong, the entries may be stored as text or the sort may not include the other columns in your records.

Quick steps for sorting dates

For a simple list, use the built-in date sort buttons. First check that each row represents one complete record and that the date column has a clear heading. Then:

  1. Click one cell in the date column. You usually do not need to select the entire column.
  2. Go to Data on the ribbon.
  3. Choose Sort Oldest to Newest for ascending order, or Sort Newest to Oldest for descending order.
  4. If Excel asks whether to expand the selection, choose Expand the selection when the neighboring columns belong to the same records, then click Sort.

Ascending order puts earlier dates first, such as January before February. Descending order puts later dates first, which is useful for seeing the most recent activity at the top. The dates’ displayed style, such as 3/8/2025 or 8-Mar-2025, does not determine the sort order when Excel recognizes them as dates.

How Excel understands dates

Excel normally stores a date as a number representing a day in its date system, then formats that number so it appears as a calendar date. The underlying value lets Excel compare dates chronologically, even when cells display them in different formats. For example, a cell displayed as 08-Mar-2025 can sort correctly alongside one displayed as 3/8/2025 if both contain actual date values.

This is why changing a cell’s number format does not always repair a bad sort. Applying a date format changes how a numeric value appears; it does not necessarily convert text that merely looks like a date into a numeric date value. Text such as 2025-03-08 may be interpreted as a date on one computer or under one regional setting, but remain text in another workbook. Excel’s ability to recognize an entry can depend on the date order and separators used by your regional settings.

Time values can also be part of a date. A cell may display only the day while containing a time as well. When two entries fall on the same date, Excel can order them by their hidden times. If that matters, format the cells to show the time or inspect the values in the formula bar.

Prepare the data before sorting

A sort is safest when the data is a continuous table: one header row followed by records, with each record kept on a single row. Remove completely blank rows or columns inside the range if they could make Excel treat part of the list as a separate block. Avoid merged cells in the data area, since they can prevent normal sorting.

  • Give the date column a recognizable header, such as Order Date or Due Date.
  • Make sure there are no stray notes or totals directly beside the data that Excel might include accidentally.
  • Check that each row has the same set of fields. Names, amounts, and status values should move with their corresponding dates.
  • If the range is likely to grow, consider converting it to an Excel table with Insert > Table. Tables make it easier to keep headers and records together as data is added.

Do not select only the date cells if other columns contain information about the same records. Sorting just one column can detach dates from names, invoices, or amounts. If Excel detects adjacent data, it may prompt you to expand the selection; accepting that prompt is generally the right choice for a structured list.

Sort dates with the Sort dialog

The quick buttons are convenient for a single date column. Use the Sort dialog when you need to confirm the range, exclude a header, or apply more than one sorting rule. Click inside the data, choose Data > Sort, and review the dialog before applying the order.

  • Check My data has headers if the first row contains labels. This keeps the header at the top instead of treating it as a record.
  • In Sort by, choose the date heading, such as Invoice Date.
  • For Sort On, leave the setting at Cell Values for a normal chronological sort.
  • In Order, choose Oldest to Newest or Newest to Oldest, then confirm with OK.

You can add another level when dates tie. For instance, sort first by Event Date from oldest to newest, then add a level for Customer Name from A to Z. Excel groups records by the primary date and orders names within each matching date. This is more reliable than sorting once by date and then sorting the entire range by name, which would make name the dominant order.

Keep complete records together

Imagine a worksheet with columns for customer, appointment date, and appointment type. Sorting only the appointment-date cells rearranges the dates while leaving customer names and appointment types in place. The sheet may still look tidy, but the information is now incorrect. Always make sure the sort range covers every field that belongs to each row.

If Excel’s selection prompt appears, choose Expand the selection for a normal multi-column list. Choosing Continue with the current selection sorts only the highlighted cells, which is appropriate only when those cells are independent of the adjacent data. For a formal Excel table, click a cell in the table and sort using the date column; the table’s records stay together.

For a more controlled sort, select the full data range first and open Data > Sort. Confirm that the displayed range includes all relevant columns and that the header option is correct. This is especially useful when there are blank columns separating related data or when the worksheet contains nearby notes that should not move.

When dates sort incorrectly because they are text

A common symptom is an order that looks alphabetical or groups values unexpectedly. For example, text dates in month/day/year form may sort by the first character or month text rather than by calendar time. Some cells may be genuine dates while others are text, especially after copying data from a website, CSV file, or another system. A mixed column can produce a result that appears only partly chronological.

Start by checking a suspicious cell. Select it and look at the formula bar and alignment: text often defaults to left alignment and may show a leading apostrophe, although formatting can change alignment, so this is only a clue. You can also temporarily apply a General number format. A recognized date typically displays as a serial number; a text date remains text. Restore the desired date format afterward.

For a whole column of consistently formatted text dates, try selecting the cells and using Data > Text to Columns. In the wizard, leave the data delimited as appropriate, proceed to the final step, choose Date, select the order that matches the source values (such as MDY or DMY), and finish. Make a copy first if the column is important, and inspect the result because choosing the wrong date order can change the meaning. For example, 04/05/2025 could mean April 5 or May 4 depending on the source convention.

Another option is to re-enter or convert the values using a method appropriate to their exact pattern. Do not assume that adding a date format alone converts text. After conversion, sort again and check a few known early and late dates to verify the chronology.

Sort dates in a filtered list or table

When filters are turned on, use the drop-down arrow in the date header and select Sort Oldest to Newest or Sort Newest to Oldest. Excel applies the order to the list while respecting the table or filtered range. Filter criteria and sort order do different things: a filter hides records that do not meet a condition, while a sort changes the order of the records that remain visible.

For example, you can filter a due-date column to show only dates in a particular period and then sort those visible records from oldest to newest. Clearing the filter makes the other records visible again, while the sort order remains applied. In an Excel table, the header drop-down combines these common filtering and sorting controls.

Use a formula to show a sorted copy

A formula can create a separate, automatically sorted view while leaving the original list in place. This is useful when the source data should remain in its original order. In Microsoft 365 or Excel 2021 and later, the SORT function returns a dynamic array that spills into cells below and to the right of the formula. Keep the spill area clear, and do not place the formula inside an Excel table if it needs to spill.

Assume A2:C5 contains four records, with names in column A, real dates in column B, and task descriptions in column C. Enter this formula in an empty cell outside the source range:

=SORT(A2:C5,2,1)

The second argument sorts by the second column of the selected range, and 1 requests ascending order. If the dates in B2:B5 are March 20, January 5, April 12, and February 14, 2025, the returned records appear in this date order: January 5, February 14, March 20, and April 12. Use -1 as the third argument for descending order. The source rows are not rearranged; the formula displays a sorted result elsewhere.

Common problems and practical checks

If the header moves into the list, reopen Data > Sort and check My data has headers. If the sort changes only one field, undo immediately with Ctrl+Z on Windows or Command+Z on Mac, then repeat the sort with the full record range. Ctrl+Z or Command+Z works for ordinary sorts, but it will not reverse every later action indefinitely, so check the result promptly.

If dates with the same day appear in an unexpected order, check for hidden time values or mixed date formats. If some records seem missing, clear any active filters before concluding that the sort deleted data. Sorting reorders cells; it does not normally remove records. For a complex workbook with formulas that refer to the sorted range, check a copy first and confirm that the formulas still refer to the intended records.

Excel for Mac and Excel for the web offer the same basic chronological sort choices, though the ribbon layout and wording can vary slightly by release. On Mac, use the Data tab’s sort controls or open Data > Sort. In Excel for the web, select a cell in the range and use the Data tab or the table-header filter arrow. If a command is not visible, widening the window or using the full Sort dialog can expose additional controls.

Frequently Asked Questions

How do I sort dates in Excel from oldest to newest?
Select a cell in the date column, choose Data > Sort Oldest to Newest, and expand the selection if Excel asks so related row data stays together.

How do I sort dates from newest to oldest?
Select a date cell and choose Data > Sort Newest to Oldest. In the Sort dialog, set the date column as the sort field and choose Newest to Oldest.

Why are my dates sorting alphabetically in Excel?
The entries may be text rather than actual date values, or the column may contain a mixture of text and dates. Convert the text using a method that matches its source date order, then sort again.

How do I sort dates without separating the rows?
Sort from a cell in the date column and accept Expand the selection when prompted. Alternatively, select the complete data range and use the Sort dialog to confirm the full range.

Can I sort by date and then by another column?
Yes. Open Data > Sort, set the date as the first level, and use Add Level to specify a second field, such as name or category.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.