To sort dates in Excel, select a cell in the date column and choose Data > Sort Oldest to Newest or Data > Sort Newest to Oldest. If Excel asks whether to expand the selection, choose Expand the selection so each date stays with the rest of its row.
Sort dates in a few steps
These steps apply to Excel for Microsoft 365 on Windows. They work for a normal data range as well as most date lists in a worksheet:
- Check that each record has its date in one column, with a clear header such as Date or Due date.
- Click a date cell in the list. You usually do not need to select the entire column or highlight every row first.
- Open the Data tab and choose Sort Oldest to Newest for ascending order, or Sort Newest to Oldest for descending order.
- If Excel displays a sort warning, select Expand the selection, then click Sort.
Oldest to Newest puts the earliest date at the top and the latest at the bottom. Newest to Oldest reverses that order, which is often useful for showing the most recent activity first. The labels refer to the dates themselves, not to how they look on the screen: a date displayed as 12-Mar-2025 still sorts by its underlying calendar value.
Why Excel can sort dates chronologically
Excel generally stores a recognized date as a number representing its position in a calendar sequence. The cell’s number format controls how that value appears, so the same date can display as 3/12/2025, 12-Mar-2025, or March 12, 2025. If Excel sees real date values, it can order them chronologically regardless of the display style.
This is different from sorting text that merely looks like a date. Text may sort alphabetically or lexically rather than by calendar order. For example, strings beginning with 1 can appear before strings beginning with 2 even when their years or months make that order incorrect. A column can also contain a mixture of real dates and text dates; those values may not behave consistently in a sort.
Formatting alone does not convert text into a date. Applying a date format to a text value may change its appearance little or not at all, while the value remains text. That distinction explains many cases where a sort seems to ignore the dates displayed in the cells.
Keep dates attached to the right records
A date column is often only one part of a record. A project deadline may share a row with a project name and owner; a transaction date may sit beside an amount and account. Sorting only the date cells can separate dates from those related details, producing a worksheet that looks plausible but contains incorrect pairings.
When the sort warning appears, choose Expand the selection. This tells Excel to move the adjacent columns along with the dates. If you choose Continue with the current selection, Excel sorts only the selected cells. That choice is appropriate only when the selected dates are intentionally independent of the surrounding data.
For more control, click a cell in the dataset and go to Data > Sort. In the Sort dialog, choose the date header under Sort by, select Cell Values under Sort On, and choose the desired order. If the first row contains headings, confirm that My data has headers is checked. Including a header as if it were a date can move it into the records or otherwise disrupt the result.
Turning a well-formed range into an Excel table can also make routine sorting safer. Select a cell in the data and use Home > Format as Table, then confirm whether the range has headers. Tables provide filter and sort controls in their header cells, and sorting a table column keeps the other table columns with their rows.
Sort by date, then by another detail
If several records share the same date, you can add a second sort level to organize ties. Open Data > Sort, set the date column as the first level, then choose Add Level and select a second column, such as customer, category, or time. For example, sort by date oldest to newest and then by customer A to Z. Excel applies the second rule among rows with matching dates.
This is useful for schedules and logs where the date alone does not determine a practical order. If a separate time column exists, use it as the second level to arrange appointments within each day. If the date cells include both date and time values, sorting by that single column can already order the combined moments; how the cells display depends on their number format.
For a quick sort in an Excel table or a range with filters, open the arrow in the date column’s header and select Sort Oldest to Newest or Sort Newest to Oldest. Filter arrows are available in tables and can be added to a range from Data > Filter. Sorting a filtered list changes the order of the records; filtering itself only hides rows that do not meet the selected conditions.
Use a formula for a separate sorted view
A regular sort changes the order of the source rows. If you want to preserve the original order and show a live sorted copy elsewhere, Microsoft 365 includes the SORT function. It returns a sorted array in a destination area, so make sure the cells where results need to spill are empty.
Assume dates are in A2:A5 and matching event names are in B2:B5, with the rows containing March 12, April 2, January 28, and February 9, 2025, in that order. Enter this formula in an empty cell outside the source range to return the complete rows from earliest to latest:
=SORT(A2:B5,1,1)
The result is January 28, February 9, March 12, and April 2, with each event name still beside its date. The second argument, 1, tells Excel to sort by the first column of the supplied range; the final 1 means ascending order. Use -1 as the final argument for newest to oldest. This formula requires Microsoft 365 or Excel 2021 or later. Unlike the Data tab sort, it creates a separate result and does not rearrange the original records.
Fix dates that sort in the wrong order
First check whether Excel recognizes the values as dates. Select a suspicious cell and temporarily choose General from the Number Format list on the Home tab. A recognized date typically appears as a number, while text often remains visibly date-like. You can also test a value directly.
Assume the date to check is in A2. This formula returns TRUE if Excel treats the cell value as a number, including a valid Excel date value, and FALSE if it is text:
=ISNUMBER(A2)
A TRUE result is a useful clue, not a guarantee that the value is the intended date: ordinary numbers are numeric too. Check a few records and compare the displayed dates with the source data, especially when the file came from a different region or application.
For text values in a consistent format, one conversion option is Data > Text to Columns. Select the date column, choose Delimited and click Next, leave delimiters unselected and click Next again. Under the column data format, choose Date and select the order that matches the text, such as MDY or DMY, then click Finish. Check the results before sorting. If the wizard is going to split or overwrite nearby data, move or copy the column to a safe area first.
Regional interpretation matters. The text 04/05/2025 can mean April 5 or May 4, depending on whether the source uses month-day-year or day-month-year. Choose the conversion order based on the source, not on a guess. If dates have mixed formats, ambiguous values, or inconsistent separators, clean and verify them individually or use a controlled import process before sorting.
Common sorting problems and how to avoid them
- Only one column moved: Undo immediately with Ctrl+Z on Windows or Command+Z on Mac, then repeat the sort and expand the selection. Undo may not be available after other actions, so inspect the rows before continuing.
- The header is among the sorted values: Use the Sort dialog and check My data has headers, or select only the records while leaving the header out.
- Dates appear grouped by year or month: Confirm the sort is using Cell Values in the Sort dialog, not a color or icon rule. A normal date-value sort should order full dates chronologically.
- Blank cells appear at one end: Blanks do not represent a calendar date and may collect separately from dated records. Decide whether to fill, filter, or leave blank records before interpreting the result.
- Rows with the same date seem unchanged: A date-only sort does not promise a meaningful order among equal dates. Add a second sort level if those records need a consistent tie-breaker.
- Dates with times look identical: The cells may contain time portions that are hidden by the format. Apply a date-and-time number format or sort with a time column as an additional level to understand the order.
Before sorting important data, save the workbook or make a copy. This is especially sensible for imported lists, shared workbooks, or ranges with complicated formulas. After sorting, check several rows across the columns to confirm that names, amounts, and other details still match their dates.
Frequently Asked Questions
How do I sort dates from newest to oldest?
Click a date in the list, then choose Data > Sort Newest to Oldest. If prompted, expand the selection so the rest of each record moves with its date.
Why does Excel sort my dates alphabetically?
The values may be text rather than Excel dates, or the column may mix text and real dates. Check representative cells, confirm the source date order, convert text dates where appropriate, and then sort again.
Can I sort dates without changing the original list?
Yes. In Microsoft 365 or Excel 2021 and later, use the SORT function in an empty area to produce a separate sorted view. A Data tab sort, by contrast, rearranges the source records.
How do I sort by month without considering the year?
A normal date sort considers the full date, including the year. If the goal is to group dates by month across multiple years, add a helper column that extracts or represents the month, then sort by that column. Check whether year order matters before choosing this approach.
Will sorting dates also sort the rows in Excel for Mac or the web?
Yes, the basic approach is similar: select a date cell and use the available sort command, making sure the full data range is included. Ribbon and menu layouts can differ slightly by platform and version; the Windows paths in this guide refer to Excel for Microsoft 365.
Related
- Export to CSV vs Excel: Which Format Should You Choose?
- Extract Data from Google Maps to Excel: Practical Options
- Export Excel to Word: Methods and Formatting Tips
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Export a Filter List in Excel: Steps and OptionsTo export filtered rows in Excel, apply your filters, select the results, copy the visible cells to a…
- Excel Vehicle Mileage Log: Setup & FormulasYou can create a vehicle mileage log in Excel by setting up a table with columns for Date,…
- Excel ROUNDUP Examples: 10 Practical Ways to RoundExcel’s ROUNDUP function always rounds a number away from zero, which makes it useful when a decimal result…
- Compare Two Lists in Excel to Find Unique ValuesTo find values in one Excel list that are missing from another, use FILTER with XMATCH; wrap the…
- Extract Day from Date in Excel: Formula and StepsTo extract the day of the month from an Excel date, put the date in A2 and enter…
- Concatenate Names in Excel With a Comma?To concatenate names in Excel with a comma and a space, use =TEXTJOIN(", ",TRUE,A2:A4) when the names are…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.