To sort dates in Excel, select a cell in the date column, then choose Data > Sort Oldest to Newest or Data > Sort Newest to Oldest. If the dates belong to rows of related information, make sure Excel sorts the entire table or range so names, amounts, and other details stay with the correct dates.
How date sorting works in Excel
Excel can sort dates chronologically because valid dates are stored as numbers, even though the cells display them in familiar formats such as 11/3/2026 or Nov 3, 2026. A date that comes earlier has a lower underlying value, so an ascending sort places earlier dates first. Excel labels that direction Oldest to Newest; descending order is Newest to Oldest.
The way a date looks on screen does not determine its chronological order. For example, 3-Nov-2026 and 11/3/2026 can represent the same date, depending on the workbook’s regional settings. If Excel recognizes both entries as dates, it can sort them together correctly even when their display formats differ. If an entry is actually text, however, it may not sort into the right chronological position.
Sorting changes the order of the existing rows. It is different from filtering, which temporarily hides rows that do not meet a condition, and different from changing a cell’s number format, which changes how a value looks without changing its place in the list.
Sort a date column from oldest to newest
For a simple list, use the sort button on the Data tab. These steps apply to Excel for Microsoft 365 on Windows:
- Click one cell in the date column. If the list has a header, click a date value rather than the header.
- Open the Data tab.
- In the Sort & Filter group, choose Sort Oldest to Newest for chronological order, or Sort Newest to Oldest for reverse chronological order.
- If Excel asks whether to expand the selection, choose Expand the selection when the other columns contain information belonging to those dates. Then confirm the sort.
For more control, select a cell in the list and choose Data > Sort. In the Sort dialog, check My data has headers if the first row contains column names. Choose the date column under Sort by, set Sort On to Cell Values, and select the desired chronological order under Order. The dialog is useful for adding additional sort levels, as well as for checking that Excel has identified the right header and field.
Keep each row’s information together
A frequent sorting mistake is selecting only the date cells when other columns describe the same records. Imagine a list with a delivery date in column A, a customer in column B, and an order number in column C. Sorting A alone would move dates without moving their corresponding customers and order numbers. The resulting rows would no longer describe the original deliveries.
When the data is in a continuous block, clicking one cell in the date column and using a sort command usually lets Excel identify the whole block. If a prompt appears, choose Expand the selection, not Continue with the current selection. If the list has blank rows or columns breaking it into separate regions, select the complete range first and then sort it. Include every column that belongs to each record.
Before sorting, check that the header row is included only as a header, not treated as a date value. In the Sort dialog, the My data has headers setting tells Excel to keep the header out of the sorted records. Avoid sorting ranges with merged cells; merged areas can prevent normal sorting or produce an error. Converting a clean rectangular range to an Excel table can make the boundaries and headers easier to manage.
Sort dates in an Excel table or filtered list
Excel tables are convenient for lists that are updated over time. To create one, select a cell in the data and choose Insert > Table, then confirm whether the table has headers. A table keeps each record together when a column is sorted and provides a dropdown in each header. Open the date column’s dropdown and choose Sort Oldest to Newest or Sort Newest to Oldest.
A regular filtered range also has dropdowns in its header row. The same date-sort options may be available there. Sorting a filtered list reorders the records; it does not mean the dates have been converted or that hidden records have been deleted. If filters are active, inspect the visible results and filter settings after sorting so you understand which rows are currently shown.
Excel for Mac has the same basic chronological sort choices, although the ribbon layout and dialog appearance can vary slightly by release. In Excel for the web, use the Data tab or a table’s header dropdown; the available controls can look different from the Windows desktop application. The underlying principle is the same: sort the date field while keeping each record’s other fields attached.
Sort by date and then by another field
Sometimes dates are not unique. If several invoices share a due date, for example, you may want the dates in chronological order and the invoice numbers in ascending order within each date. Use the multi-level Sort dialog rather than sorting each column separately:
- Select a cell in the full data range and choose Data > Sort.
- Set the first level to the date column, with Cell Values and Oldest to Newest.
- Select Add Level, choose the second field, such as invoice number or customer name, and set its order.
- Add another level if needed, then select OK.
Excel applies the first level to the complete list and uses later levels to order records that tie at an earlier level. For instance, set Date as the first level and Priority as the second to group records by date while arranging same-day records by priority. Sorting by a second field first and then sorting by date separately is not a reliable substitute, because the later sort can disrupt the grouping you intended.
Dates that include times
A cell can hold both a date and a time. When these values are sorted, Excel considers the time as well as the date, even if the cell format displays only the date. As a result, two entries that appear to have the same day can still have a definite order. If you need to review that detail, apply a format that displays both date and time, or inspect the value in the formula bar.
For example, a log may contain entries at 9:00 a.m. and 2:00 p.m. on the same day. An oldest-to-newest sort places the morning entry first. If the time is irrelevant to the task, decide whether the underlying values should be changed or whether a separate date-only field is more appropriate; simply hiding the time with a number format does not remove it.
For schedules that repeat by month or weekday, a normal date sort still sorts by full date, including year. Thus dates from different years will not automatically be grouped as January, February, and so on. If you want a month-by-month comparison across years, create a separate analysis that groups or extracts the month rather than expecting a standard chronological sort to ignore the year.
Fix dates stored as text
If a date column sorts oddly, some entries may be text rather than actual Excel dates. Text values can look identical to dates but sort alphabetically or appear in a separate group. A warning sign is that a few entries remain out of order, align differently from neighboring values, or fail to change when you apply a date number format. Alignment alone is not definitive, since formatting can override Excel’s usual display.
One conversion option is Data > Text to Columns. Select the affected cells, open the wizard, choose Delimited and select Next, then select Next again. Under Column data format, choose Date and the order that matches the text, such as MDY or DMY, then select Finish. Check a few converted values before sorting. The correct date order matters: 04/05/2026 can mean April 5 or May 4, depending on the source convention.
Do not guess the date order based on a single ambiguous value. Look for a date with a day number greater than 12, consult the data source, or check the workbook’s regional expectations. If text values use inconsistent patterns, clean or convert them in separate groups rather than applying one assumed order to everything. Keep a copy of the original data until you have confirmed that the converted dates are correct.
Common problems and safe checks
If a sort seems wrong, first check whether every cell in the column is a real date and whether the sort covered the complete set of related columns. Also look for blank rows splitting the data, stray spaces or text entries, and dates entered with different regional conventions. A displayed date format cannot repair text that Excel does not recognize as a date.
- Only one column moved: undo the sort immediately and repeat it with the complete range, or choose Expand the selection when prompted.
- The header moved into the records: open the Sort dialog and set My data has headers correctly.
- Some dates are out of place: inspect those cells for text values, mixed date conventions, or hidden time values.
- The dates look different after sorting: sorting normally does not change their values, but different cell formats can make equivalent dates display differently. Apply a consistent date format if a uniform appearance is useful.
If you make an unwanted sort, use Ctrl+Z on Windows or Command+Z on Mac to undo it, provided you have not performed another action that changes the undo history. For important workbooks, save a copy before major cleanup or reordering. Sorting does not delete records, but a mistaken partial sort can make a dataset misleading and may be difficult to spot later.
Sorting manually versus a formula
A standard sort rearranges the existing records in place, which is best when you want the worksheet itself reordered. If you instead want a separate, automatically updating sorted view, Excel 2021 and Microsoft 365 include the SORT function. With event names in A2:A4 and actual Excel dates in B2:B4, enter =SORT(A2:B4,2,1) in an empty area. It returns the two-column records sorted by the second column, oldest date first; for example, rows dated January 10, March 1, and June 15 appear in that order. The source range remains unchanged, and the results spill into nearby cells, so leave enough empty space for them.
A formula-based result is useful for a report that should update when the source values change, while a normal sort is simpler for a one-time rearrangement. SORT is not available in every older Excel release, and a spilled formula cannot place results over occupied cells. If you need to share the workbook with people using older versions, an ordinary sort or a copied values-only result may be more compatible.
Frequently Asked Questions
How do I sort dates from newest to oldest in Excel?
Click a date in the list and choose Data > Sort Newest to Oldest. If Excel asks whether to expand the selection, expand it so other details in each row stay together.
Why are my dates sorting alphabetically instead of chronologically?
Some entries are likely stored as text. Convert them to real dates using a suitable method such as Data > Text to Columns, selecting the date order that matches the source, and then sort again.
Can I sort dates without separating the rest of the row?
Yes. Sort the complete data range or use an Excel table, and choose Expand the selection if prompted. Do not sort only the date cells when neighboring columns contain related record details.
How do I sort by date and then by name?
Choose Data > Sort, set Date as the first level, then select Add Level and choose Name as the second level. Excel sorts names within records that have the same date.
Why do two entries with the same displayed date change order?
They may contain different times that are hidden by the date-only format. Excel sorts by the full date-and-time value, so display both components to check whether the entries differ.
Does changing the date format sort the list?
No. Formatting changes how a value appears, not the order of the rows. Use a sort command to rearrange records; use number formatting only to change how recognized dates are displayed.
Related
- Real Estate Excel Template for Cash Flow: Build One
- Real Estate Excel Budget Template: Setup and Costs
- Randomize Numbers in Excel Without Duplicates
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Create an Email Signature in Outlook on the WebTo create an email signature in Outlook on the web, open Settings (the gear icon), go to Accounts…
- Excel Shortcut to Select an Entire Column on WindowsIn Excel for Microsoft 365 on Windows, press Ctrl+Space to select the entire column containing the active cell.…
- How to Add a Date Stamp to a Checkbox in ExcelTo add an automatic date stamp to an Excel checkbox, place the checkbox in column B, use the…
- Adding a Dropdown in Google SheetsTo add a dropdown in Google Sheets in a web browser, select the cell or cells, choose Insert…
- How to Remove Duplicates in Google SheetsTo remove duplicate rows in Google Sheets, select your whole data range, then choose Data > Data cleanup…
- Vacation Meal Planning Template Excel: Plan Every DayYes. A useful vacation meal planning template in Excel has a daily menu, a grocery list with quantities…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.