To sort dates in Microsoft Excel for Microsoft 365 on Windows, select a cell in your date column and choose Data > Sort Oldest to Newest or Data > Sort Newest to Oldest. Sort the whole table or data range—not just the date column—so each date stays with its corresponding row.
Sort a range by date in a few steps
For a simple list, Excel can sort dates with one command. First confirm that your list has a date heading, such as Order Date, and that the rows below it contain the dates and related information. Then:
- Click a cell inside the data range, or select the complete range, including all columns that belong together.
- Open the Data tab.
- Choose Sort Oldest to Newest to put earlier dates first, or Sort Newest to Oldest to put later dates first.
- If Excel asks whether to expand the selection, choose Expand the selection, then confirm the sort.
Expanding the selection is important when you initially select only the date column. It tells Excel to move each row as a unit. If you sort that column by itself, names, amounts, or other details can become associated with the wrong dates. When the entire range is selected before sorting, Excel does not need to ask whether to expand it.
Use the Sort dialog for more control
The Sort dialog is useful when you want to check which column Excel will sort, have several headings, or need more than one sorting rule. Click inside the data and choose Data > Sort. In the dialog, check My data has headers if the first row contains labels. Under Sort by, select the date heading, set Sort On to Cell Values, and choose the order.
For the date order, select Oldest to Newest for ascending chronological order or Newest to Oldest for descending chronological order. The dialog can also add levels, such as sorting first by date and then by customer name. Use Add Level to add another rule and set its column and order. The first level takes priority; the next level sorts records that tie on the first one.
If your data has no header row, clear My data has headers so Excel treats the first row as data. Otherwise, Excel may leave that row out of the sort or interpret the first date as a heading. Check the preview fields in the dialog before clicking OK, especially when the list contains several columns with similar names.
Choose the right sort direction
Oldest to Newest means ascending order: January dates come before February dates, earlier years come before later years, and dates within a month progress from the first day to the last. This is often best for timelines, historical records, and a schedule that starts at the beginning.
Newest to Oldest means descending order. The most recent entry appears first, which is convenient for reviewing the latest sales, payments, service requests, or updates. It does not change the date values or remove older records; it only changes the order in which rows appear.
Sorting is different from filtering. A sort rearranges records, while a filter temporarily hides rows that do not meet a condition. If you want to see only dates in a particular month without changing the order of the remaining records, use the filter menu on the date heading instead of sorting alone.
Sort dates in an Excel table
Excel tables make sorting a growing list easier because the table keeps related columns together and includes new rows in its structure. To sort one, click the arrow in the date column heading and select Sort Oldest to Newest or Sort Newest to Oldest. The table applies the order to complete records, rather than moving just the date values.
If the data is an ordinary range and you want table behavior, select a cell in the range and choose Insert > Table, then confirm whether the range has headers. You can also use Ctrl+T on Windows. An existing table does not have to be converted just to sort; the heading dropdown is simply a convenient option.
In Excel for Mac and Excel for the web, the ribbon layout or wording can differ slightly from Windows. The same basic approach applies: use the Data tab’s sort commands or the dropdown on the table’s date heading, and verify that the full table is being sorted. A table heading dropdown is especially helpful when the ribbon arrangement is different.
Sort by date and another column
A single date sort can leave records with identical dates in an order that is not meaningful for your task. Add another sort level when you want a consistent tie-breaker. For example, to group orders by date and arrange same-day orders by customer, open Data > Sort, set the first level to Order Date, and add a second level for Customer Name.
For a schedule that needs to group dates and then prioritize work, use the date as the first level and a priority column as the second. Choose the priority order that suits the labels in your sheet. If priority values are text such as High, Medium, and Low, an alphabetical sort may not reflect the order you intend; you may need to use a custom list or a separate numeric priority field.
Use levels when you need different fields to control the order. Sorting by date first and then by a second field is not the same as sorting by the second field first. Excel applies the first level to the whole list and only uses later levels to order records tied at earlier levels.
Why dates sometimes sort incorrectly
The most common cause is that some entries are dates Excel recognizes as values while others are text that merely looks like a date. Excel stores recognized dates as serial numbers, so it can compare their chronological values. Text entries may instead sort alphabetically or appear apart from genuine dates. A column can look consistent while still containing a mixture, particularly after data is pasted from a website, a CSV file, or another system.
Look for clues such as dates that stay out of sequence, values that align differently from neighboring entries, or a sort that separates some entries from the rest. Alignment alone is not a definitive test, because formatting can change how cells look. Also check for leading apostrophes, spaces, or inconsistent date conventions. For instance, a value written as 04/05/2025 is ambiguous: it can mean April 5 or May 4, depending on the date convention used when it was entered or imported.
For text dates in a consistent format, select the affected cells and use Data > Text to Columns. In the wizard, proceed to the final step, choose Date, select the order that matches the source data (such as MDY or DMY), and click Finish. Make a copy of the data first if the original values need to be preserved. Check the converted results before sorting, especially if the source contains ambiguous dates or multiple formats.
Changing a cell’s number format to a date display does not convert text into a real date. It only changes the appearance of values Excel already recognizes as numbers or dates. If Text to Columns is not appropriate, check the source and regional date convention, remove unwanted spaces, and convert the entries using a method suited to that data before sorting. Avoid assuming that a display such as 5/4/2025 has the same meaning in every locale.
Understand date formats, times, and blank cells
Sorting uses the underlying value, not the way the date is displayed. A cell containing the same date can be formatted to show a short date, a long date, or a month and year, yet its chronological position remains the same. You can change the display with Home > Number Format after sorting if the dates are difficult to read.
Some records include a time as well as a date. Excel stores a time as part of the date-time value, so two entries on the same calendar day can still be ordered by time. If the times are hidden by the current number format, the rows may appear to have matching dates even though their underlying values differ. Use a format that displays the time if the within-day order matters.
Blank cells and incomplete records can make the result look unexpected. Decide whether undated rows should remain in the list, be completed, or be separated before sorting. Do not fill missing dates with an invented value just to force a preferred position. After sorting, review the top and bottom of the range and check that all relevant records are still present.
Prevent common sorting mistakes
Before sorting a consequential list, make a quick check of its structure. One stray blank row can divide a range, and an accidentally omitted column can separate information that belongs together. If the prompt offers to expand the selection, choose that option for a normal contiguous dataset. For an Excel table, sort from a table heading so the table handles its own rows.
- Include every column that belongs to each record, not only the date column.
- Confirm that headings are identified correctly and that no heading is included as an ordinary record.
- Check for text dates, inconsistent regional formats, and hidden times if chronology looks wrong.
- After sorting, compare a few records against their original details and make sure the date order matches the intended direction.
Sorting does not delete records, but it does change their positions. If a particular order must be restored later, keep a separate original-order or ID column before sorting. A unique record ID is useful for matching details back to their source; a simple sequence number can preserve the initial order if it is assigned before any sort. Saving a copy first is sensible when the workbook is important or the data has no easy way to reconstruct its previous order.
Frequently Asked Questions
How do I sort Excel dates from newest to oldest?
Click inside the table or select the complete data range, then choose Data > Sort Newest to Oldest. In the Sort dialog, select the date heading and choose that order. Keep the related columns included so each row stays intact.
Why is Excel sorting my dates alphabetically?
Some or all of the entries may be text rather than recognized date values. Convert the text using a method that matches the source date order, such as Data > Text to Columns, then sort again. Changing the display format alone does not convert text to dates.
Can I sort by month without sorting by year?
A normal date sort considers the complete date, including its year. If you need to group all January entries together across different years, add a helper column that extracts the month or use a PivotTable grouping approach. Keep the original full date so the year and day are not lost.
How do I sort dates without separating rows?
Select the whole data range before sorting, or sort from the dropdown in an Excel table heading. If Excel asks whether to expand the selection, choose Expand the selection. Never sort only the date cells when other columns contain details for those dates.
Can Excel sort dates that include times?
Yes. A recognized date-time value sorts chronologically, including the time portion. If same-day entries look identical, apply a number format that displays both date and time to confirm their order.
Related
- Kitchen Prep List Excel Template: Build a Clear Sheet
- Excel 365 Keyboard Shortcuts: Essential Keys and Tips
- Keyboard Shortcut to Ungroup in Excel (Windows & Mac)
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Formula for Calendar Days Between DatesTo calculate calendar days between two dates in Excel, subtract the earlier date from the later one: with…
- Excel Filter Shortcut Key: Turn Filtering On or OffTo apply a filter in Excel for Microsoft 365 on Windows, click a cell in your data range…
- How to Close the Formula Bar in Excel on Any DeviceTo close—or hide—the formula bar in Excel, open the View tab and clear the Formula Bar checkbox. In…
- Excel IRR for Monthly Cash Flows: Formula and ExamplesFor equally spaced monthly cash flows in B2:B14, enter =IRR(B2:B14) to calculate the rate per month; the first…
- How to Filter Purchases by Date in Excel, Step by StepTo filter purchases by date in Excel, select your purchase list, choose Data > Filter, open the arrow…
- Find a Position in Excel with MATCH and XMATCH FormulasTo find where a value sits within a list, use MATCH or XMATCH. If the value to find…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.