Sort Excel Oldest to Newest: Dates, Data, and Fixes

Formulas & functions · Updated November 18, 2026

To sort dates in Excel from oldest to newest, select a cell in the date column, then choose Data > Sort Oldest to Newest. If Excel asks, choose Expand the selection so each date stays with its complete row. For more control, open Data > Sort and set the date column’s order to Oldest to Newest.

The quickest way to sort dates

In Microsoft Excel for Microsoft 365 on Windows, the one-click sort is usually the fastest option when your data has one clear date column and you want to sort the entire list by that column. Use these steps:

  1. Click a cell containing a date in the list. You do not need to select the whole date column.
  2. Open the Data tab and, in the Sort & Filter group, choose Sort Oldest to Newest.
  3. If Excel displays a Sort Warning, choose Expand the selection, then click Sort.

Excel moves complete rows into date order, placing the earliest date first and the latest date last. For example, dates entered as March 14, 2025; January 5, 2024; and October 2, 2024 become January 5, 2024; October 2, 2024; and March 14, 2025. The displayed date style does not determine the order if Excel recognizes the entries as real dates.

You can also use the sort option on a table or range’s filter arrow. Open the arrow in the date-column header and choose Sort Oldest to Newest. In Excel for Mac and Excel for the web, the ribbon layout can differ slightly, but the Data tab’s date-sorting command or the header filter menu provides the same basic operation.

How Excel understands dates

Excel normally stores a date as a serial number rather than as a piece of text. The number represents a day in Excel’s date system, and a date format controls how that value appears on screen. This is why January 5, 2024 can display as 1/5/24, 05-Jan-2024, or another regional format while still sorting as the same date.

That distinction matters because something that looks like a date may actually be text. A date copied from a website, imported from a CSV file, or entered in a format Excel does not recognize can remain a text string. Text may sort alphabetically or separately from real dates, producing an order that looks wrong even though the sort command worked as designed.

To check a suspicious value, select its cell and look at the formula bar and number format. You can also temporarily change the cell’s format to General from Home > Number. A recognized date will usually display as a serial number; a text date continues to display as text. Restore the desired date format after checking. A left-aligned appearance can be a clue that a value is text, but alignment alone is not conclusive because formatting can change alignment.

Keep each date attached to its row

A date usually identifies a record, not an isolated value. If a worksheet has a date in column A, a customer in column B, and an amount in column C, sorting only column A would put dates beside the wrong customers and amounts. This is one of the most damaging spreadsheet sorting mistakes.

When Excel detects nearby data, it often offers to expand the selection. Choose Expand the selection to include the connected columns. Choosing Continue with the current selection sorts only the selected cells and is appropriate only when those cells are genuinely independent of the other columns. If no warning appears, inspect the result immediately and use Ctrl+Z on Windows or Command+Z on Mac to undo a mistaken sort.

For reliable results, keep one header row at the top, avoid completely blank rows or columns inside the list, and make sure each record occupies one row. Excel uses the surrounding data to infer the range, so an empty row can make it treat part of a list as a separate block. Converting a well-structured range to a table with Insert > Table also gives Excel a defined data region and filter arrows for each header.

Use the Sort dialog for more control

The one-click command sorts by a single column. Use Data > Sort when you need to confirm headers, choose a specific range, or apply more than one sorting rule. In the Sort dialog, check My data has headers if the first row contains labels such as Date or Order ID. Then choose the date field in Sort by, leave Sort On set to Cell Values, and select Oldest to Newest under Order.

You can add a secondary rule with Add Level. For example, sort first by date from oldest to newest and then by customer name from A to Z. The date determines the main sequence; the customer rule orders records that share the same date. You can add further levels for other fields, such as department or invoice number. Check the level order in the dialog: the first level takes priority, and later levels break ties.

The Sort dialog is also useful when a worksheet has several columns of similar-looking dates. Selecting the intended field by its header reduces the chance of sorting by the wrong date, such as a payment date instead of an order date. It makes the chosen order visible before you commit the sort, which is helpful for a report or shared workbook.

Fix dates that are stored as text

If the list does not sort chronologically, first determine whether the dates are text. Mixed imports are common: some rows may be genuine Excel dates while others are text, especially when source files use different regional conventions. For instance, 04/05/2024 can mean April 5 or May 4 depending on the source’s date convention. Do not convert ambiguous dates until you know which interpretation is correct.

For consistently formatted text dates, try selecting the affected column and choosing Data > Text to Columns. In the wizard, proceed through the steps, choose Date as the column data format, select the source order such as MDY or DMY, and finish. Check the results before sorting, because selecting the wrong order can silently turn a valid-looking date into a different day or month. The Mac wizard’s appearance may differ, but the conversion depends on choosing the correct date order.

Another option is to use Excel’s warning or conversion prompt when it identifies text dates, if that prompt is available for the selected cells. For a complicated import, it may be safer to work on a copy, inspect representative values, convert them consistently, and compare the first and last dates with the source. Changing the cell format alone does not convert text into dates; number formatting changes appearance, not the underlying value.

Times, blanks, and duplicate dates

A cell can contain both a date and a time. Excel stores the time as a fraction of a day, so two entries displayed as April 8, 2024 may still have different underlying values. When sorted, the earlier time comes first within that day. If the time is hidden by the cell format, the apparent order can seem inconsistent. Apply a format that shows both date and time to inspect those records.

Blank date cells are not dates, so they can appear apart from the chronological sequence. In an ascending sort, blanks commonly appear after dated values, but mixed data and the selected range can affect what you see. If blanks need special treatment, decide whether to leave them at the end, fill them with a meaningful date, or filter them out before sorting. Do not enter a made-up date merely to force a preferred position.

Duplicate dates are valid. Excel does not remove repeated records when it sorts. Their relative order may not be a useful way to distinguish them, so add a secondary sort level such as time, transaction ID, or name when a specific order among ties matters. If two rows have the same values for every selected sort level, the sort criteria do not provide a meaningful distinction between them.

Sort a copy without rearranging the source

If you want a separate, automatically updated sorted view while keeping the original list in place, Microsoft 365 and Excel 2021 or later include the SORT function. It returns a sorted copy of a range rather than moving the source cells. Enter the formula in an empty area with room for the results to spill; the output area must not contain data that blocks it.

With dates in A2:A4 and matching event names in B2:B4, where the rows are March 14, 2025 / Review, January 5, 2024 / Launch, and October 2, 2024 / Draft, enter this formula in an empty cell:

=SORT(A2:B4,1,1)

The formula sorts the first column in ascending order and returns the matching event names alongside their dates: Launch, Draft, then Review. The first argument is the range, the second identifies the first column within that range as the sort key, and the third requests ascending order. Because the source is unchanged, edits to the source can update the sorted result. This is useful for a report view, but it does not replace a sort when you need to physically rearrange the original records. SORT is not available in some older Excel releases.

Common sorting mistakes to avoid

  • Sorting one column alone: Include the complete record so the fields remain together.
  • Assuming the display format fixes the value: A text date formatted to look like a date is still text until it is converted.
  • Ignoring regional date order: Confirm whether imported dates use month-day-year or day-month-year before conversion.
  • Including a title row as data: Use the Sort dialog’s header option or select the actual list with its header.
  • Expecting a sort to remove duplicates: Sorting changes order; it does not delete repeated rows.

Before sorting a large or important workbook, save a copy or confirm that the action can be undone. Afterward, check a few records near the top and bottom, and verify that identifying fields still match their original dates. These quick checks catch a wrong range, a text-date problem, and an unintended sort key before the order is used in a report.

Frequently Asked Questions

How do I sort dates from oldest to newest in Excel?
Select a cell in the date column and choose Data > Sort Oldest to Newest. If prompted, expand the selection so the full rows move together.

Why are my dates sorting alphabetically instead of chronologically?
Some or all of the entries may be text rather than Excel date values. Check how Excel stores the cells, then convert the text using the correct regional date order before sorting again.

How do I sort dates without separating the other columns?
Sort from a cell in the date column and choose Expand the selection when Excel asks. Alternatively, use Data > Sort and select the date field while including the complete table or range.

Can I sort dates and then sort names within each date?
Yes. Open Data > Sort, set the date column to Oldest to Newest, choose Add Level, and set the name column to A to Z.

Can Excel sort dates that include times?
Yes. Excel sorts the underlying date-and-time values, including times that are not visible in the current cell format. Show the time in the format if records on the same date appear out of order.

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.