To sort dates from oldest to newest in Excel for Microsoft 365 on Windows, click a date cell in the list, then choose Data > Sort Oldest to Newest. If the dates belong to rows of related information, make sure Excel sorts the entire table or range—not just the date column—or the records can become mismatched.
That quick command works when Excel recognizes the entries as dates. If the order looks wrong, the values may be text, the selected range may be incomplete, or the cells may contain dates with times. The sections below explain how to sort safely and how to diagnose those cases.
Sort a date column with the ribbon
For a simple, contiguous list, use the ascending sort button. Excel calls ascending date order Oldest to Newest; it is the date equivalent of sorting numbers from smallest to largest. These steps apply to Excel for Microsoft 365 on Windows:
- Click one cell in the date column. If the list has a header such as Date, click a date value rather than the header.
- Open the Data tab.
- In the Sort & Filter group, choose Sort Oldest to Newest. Depending on the ribbon layout, the command may appear as a date or A-to-Z-style sort button with a tooltip.
- If Excel asks whether to expand the selection, choose Expand the selection when other columns contain information for the same records. Then click Sort.
Excel should rearrange the records so the earliest date appears at the top and the latest at the bottom. For example, dates entered as 4/12/2023, 11/3/2022, and 1/8/2024 should sort as 11/3/2022, 4/12/2023, and 1/8/2024, assuming the entries are interpreted as month/day/year dates.
Keep each date with its full row
A date is often one field in a record that also contains a customer, task, amount, or status. Sorting only the date cells while leaving the other columns in place breaks those relationships. The date for one transaction could end up beside another transaction’s amount, for example.
When Excel detects neighboring data, it may automatically include the surrounding columns. If it shows a choice, select Expand the selection, not Continue with the current selection. The latter sorts only the highlighted cells. Before confirming, check that the proposed range includes every column and row that belongs to the list.
For data you sort often, convert the range to an Excel table. Select a cell in the data and choose Insert > Table, confirm the range, and indicate whether it has headers. A table treats each record as a row, so sorting its Date column keeps the other fields together. You can then use the arrow in the Date header and choose the ascending date sort. Avoid including unrelated notes or totals as part of the table.
Use the Sort dialog for more control
The ribbon’s one-click button is convenient, but the Sort dialog is useful for several date columns, multiple sorting rules, or a range where you want to confirm exactly what Excel will do. Click within the data and choose Data > Sort. In the dialog, set Sort by to the date column, Sort On to Cell Values, and Order to Oldest to Newest. If your first row contains field names, make sure My data has headers is selected.
You can add a secondary rule with Add Level. For example, sort first by Appointment Date from oldest to newest, then by Customer Name from A to Z. Excel uses the second rule to order records that have the same value in the first key. This is different from sorting by Customer Name first, which would group the customers before considering the appointment dates.
A two-level sort is also useful when dates repeat and you want a predictable order within each day. Add the relevant field as the second level, such as Start Time or Invoice Number. Check the sort levels from top to bottom: the first level has priority, and lower levels resolve ties.
How Excel stores and sorts dates
Excel normally stores a date as a serial number, rather than as the exact characters shown on screen. The number represents the date in Excel’s date system; a cell’s number format controls how that value is displayed. That is why a date shown as 12-Apr-2024 can sort correctly alongside one displayed as 4/12/2024: if both are real dates, Excel compares their underlying values, not the way they look.
This distinction also explains a common surprise. Changing a cell’s format to Date does not necessarily convert text that merely looks like a date into a real date value. Formatting changes the display of values Excel already recognizes; it cannot reliably fix every text entry. If Excel is treating a date as text, the sort may follow text order rather than calendar order.
Regional settings matter when dates are typed or imported. For example, 3/4/2025 can mean March 4 or 3 April depending on the date convention Excel uses to interpret the entry. Once Excel has interpreted and stored the value, sorting follows that stored date—even if the original entry was intended differently. Confirm ambiguous dates against the source before sorting or converting them.
Fix dates that sort in the wrong order
If a date sort produces an order such as 1/10, 1/2, 1/25 instead of calendar order, check whether the cells are text. A telltale sign is that some dates align differently from other values, but alignment alone is not conclusive because cell formatting can change alignment. Test a few entries by changing their number format to a date or general format, and compare them with dates you know Excel handles correctly. A mixed column can contain both real dates and text dates.
For a consistent text format, Text to Columns can convert the values. First make a copy of the column or workbook so you can compare the result. Select the affected cells, choose Data > Text to Columns, select Delimited, and click Next twice. Under Column data format, select Date and choose the order that matches the source—for example, MDY for month/day/year or DMY for day/month/year. Click Finish, then check several converted entries before sorting. The wizard’s date choice must match the actual input; choosing the wrong order can silently produce incorrect dates.
If the entries use different formats, do not convert the whole column blindly. Work out which values are ambiguous and verify them from the original records. You may need to clean or standardize the entries first. For dates imported from another system, check whether that system exported actual date values or text, and whether the export’s regional convention matches Excel’s.
Handle blank cells, headers, and times
Blank cells can appear at one end of a sorted range, so decide whether that placement is acceptable before sharing the result. If blank dates mean something specific—such as an appointment not yet scheduled—consider filtering them separately or filling them only with a meaningful, verified value. Do not replace missing dates with an invented date just to make the list look complete.
Headers should remain at the top, not be sorted as if they were dates. Excel usually detects a header when you sort a well-formed range, but the Sort dialog’s My data has headers setting is worth checking, particularly if the header resembles a value or the selection starts below the actual header.
A cell can also contain both a date and a time. Excel sorts by the full underlying value, so two appointments on the same day may be ordered by time even if the cell format displays only the date. If you need time-of-day order, show a time format or inspect the values; if you want records grouped by calendar day regardless of time, make sure your sorting approach uses a date-only field.
Sort without changing the original list
If you want a separate sorted view and have Microsoft 365 or Excel 2021, the SORT function can return a sorted copy. Suppose dates are in A2:A10 and the associated details are in B2:B10, with the date in the first column. Enter =SORT(A2:B10,1,1) in an empty area. The formula sorts the selected two-column array by its first column in ascending order, so the dates run from oldest to newest and each detail remains beside its date. The result spills into nearby cells; leave enough empty space for it.
This formula does not rearrange the source data. It creates a live sorted result that updates when the source range changes, which can be useful for a report or a view that should not alter the original order. It will not fix text dates: the source values still need to be valid dates for dependable chronological sorting. If the result area is blocked by existing content, Excel cannot spill the output until that space is cleared.
For a one-time sort, the ribbon or Sort dialog is usually simpler. Use a formula when you specifically need a second, automatically updating view. In Excel for the web, the ribbon also provides sorting commands for a selected range or table; the precise button placement can differ with the window width. Excel for Mac has comparable sort commands on the Data tab, though ribbon layout and dialog wording may vary slightly.
Frequently Asked Questions
How do I sort dates from oldest to newest in Excel?
Click a date in the list and choose Data > Sort Oldest to Newest. If Excel asks whether to expand the selection, expand it so related columns move with each date.
Why are my dates sorting alphabetically instead of chronologically?
Excel may be treating some or all of the entries as text, or the column may contain mixed text and real dates. Convert text dates using the correct source date order, then sort again and verify sample results.
How do I sort dates without separating the other columns?
Select a cell in the date column and expand the selection when prompted, or sort the Date column of an Excel table. Confirm that the entire record range is included before applying the sort.
Can I sort dates in Excel while keeping the original order?
Yes. In Microsoft 365 or Excel 2021, use SORT to create a separate sorted output, such as =SORT(A2:B10,1,1) when the dates are in the first column of A2:B10. The source range stays in its original order.
Does changing the cell format turn text into a real date?
Not necessarily. Applying a date format changes how recognized date values appear, but text may remain text. Convert the values with an appropriate method, such as Text to Columns, and check that the chosen date order matches the original data.
Related
- Excel Data Validation List With a Blank Option
- Excel Data Validation List Without a Cell Reference?
- Excel German Number Format: Commas, Dates, and Currency
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Formula for the Greater of Two CellsTo return the larger of two cell values in Microsoft Excel, use =MAX(A2,B2). This example assumes the two…
- Excel Subtotal Filtered Rows: Formula, Steps, and FixesYes. In Excel for Microsoft 365 on Windows, use the SUBTOTAL function to calculate from rows that remain…
- Excel MATCH Arguments: What Each One DoesExcel’s MATCH function has three arguments: MATCH(lookup_value, lookup_array, [match_type]). The first two say what to look for and…
- Excel Find and Replace: Values, Formulas, and OptionsTo find and replace values in Excel, press Ctrl+H on Windows, enter the text or value under Find…
- LEFT, RIGHT and MID Formulas in Excel: How to Use ThemUse LEFT to return characters from the start of a text value, RIGHT to return them from the…
- Excel Formula for Random Selection From a List: GuideTo return one random item from a contiguous list in Excel, use =INDEX(A2:A20,RANDBETWEEN(1,ROWS(A2:A20))). If your items are in…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.