How to Sort Dates Correctly in Excel Without Errors

To sort dates correctly in Excel, make sure Excel recognizes the entries as real dates, then select a cell in the data and choose Data > Sort Oldest to Newest or Data > Sort Newest to Oldest. If dates are stored as text, convert them first; otherwise Excel may sort by characters instead of calendar order. These steps are for Microsoft Excel for Microsoft 365 on Windows.

What You’ll Need

An Excel workbook with a date column and, if applicable, related details such as names, amounts, or notes in adjacent columns.
Permission to edit the workbook. If the file is shared or important, save a copy before changing its data.
For text-date conversion, a clear idea of the order used in the source dates, such as month/day/year, day/month/year, or year-month-day.

Step-by-Step

Check how the dates are arranged. Look at several entries in the date column, not just the first one. Dates such as 3/4/2025 are ambiguous: they could mean March 4 or April 3, depending on the source convention. Also look for entries that use different separators, include times, or contain extra spaces. Knowing the source format helps you avoid converting dates to the wrong calendar day.
Check whether Excel recognizes the values as dates. Select a date cell and look at the formula bar. A value that is a real date usually appears as a date there, even if the cell itself uses a different display format. You can also temporarily set a cell’s format to General from Home > Number Format. A real date will usually show a number, because Excel stores dates as serial values; a text entry will remain text. Formatting alone does not turn text into a date.
Convert text dates when necessary. If all the text dates follow one consistent pattern, select only the date cells, then choose Data > Text to Columns. In the wizard, choose Delimited and select Next twice. Under Column data format, choose Date and select the order that matches the original text, such as MDY, DMY, or YMD. Select Finish. Check a few converted results against the source before sorting. This operation changes the selected cells, so copy the original dates to another column or save a workbook copy if you need to preserve them.
Use a helper formula for a consistent year-month-day text pattern, if needed. For example, if A2:A100 contains text dates exactly like 2024-03-07, enter this in B2 and fill it down: =DATE(LEFT(A2,4),MID(A2,6,2),RIGHT(A2,2)). For the text 2024-03-07, the formula returns a real date that displays as March 7, 2024 when formatted as a date. Apply a date format from Home > Number Format, check the results, and sort using the helper column. This formula is for consistently positioned YYYY-MM-DD text; it is not a general converter for mixed formats or ambiguous dates.
Include the complete records in the sort. If a date belongs to a row of information, click a cell in the data range and choose Data > Sort. Excel will usually identify the surrounding data. In the Sort dialog, confirm the full table or range is included, check My data has headers if the first row contains column names, and choose the date field under Sort by. Sorting only the date column can detach dates from their corresponding names, amounts, or other details.
Choose the sort order. In the Sort dialog, set Sort On to Cell Values, then choose Oldest to Newest for ascending chronological order or Newest to Oldest for descending order. Select OK. If you are sorting a single date column with no related row data, you can instead select a date cell and use Data > Sort Oldest to Newest or Data > Sort Newest to Oldest.
For a formatted Excel table, sort from its date header. Click the filter arrow in the date column’s header and select Sort Oldest to Newest or Sort Newest to Oldest. The table’s rows stay together. If filters are not available, select the data and choose Home > Format as Table, confirm the range and whether it has headers, and select OK. Check that the table includes every related column before sorting.
Verify the result. Scan the first few and last few dates and check important records against their original rows or source. For ascending order, dates should move forward in time; for descending order, they should move backward. If the column includes times, entries on the same day may be ordered by time, which is normal. Save the workbook after confirming both the dates and their associated row details are correct.

Common Mistakes

Sorting text as if it were dates: Text can be arranged alphabetically or by character rather than by calendar value. That can put dates in a sequence such as 1/10, 1/2, 1/3, depending on the text format. Convert the values to real dates before sorting.

Choosing the wrong date order during conversion: A text value such as 04/05/2025 can be interpreted as April 5 or May 4. Confirm the source convention before selecting MDY or DMY in Text to Columns. Do not guess from a date where both numbers are 12 or lower.

Sorting one column in a multi-column list: This can mismatch dates and the records they describe. Use the full data range or sort an Excel table by its date header. If Excel warns that data exists next to the selection, choose Expand the selection, not Continue with the current selection.

Including the header as a date: If Excel treats a heading such as “Order date” as a record, verify the range and check My data has headers in the Sort dialog.

Assuming a date format fixes text: Applying a date display format changes how numeric dates look; it does not convert text into numeric date values. Convert the underlying values first.

Tips

Use four-digit years in source data to reduce confusion between centuries, and use one consistent format when importing or entering dates.
For new data, enter dates in a format Excel recognizes in your regional settings. If a date is ambiguous, type it using the month name, such as 7 Mar 2024, then check that Excel recognizes it.
Consider turning a regularly updated range into an Excel table. Its header filters make sorting one field straightforward, and newly added rows can be included in the table.
If two records share a date and need a predictable order, use Data > Sort and add a second level, such as a name or ID column. The date remains the primary sort key.
When working with imported data, keep a copy of the original date column until you have checked the converted values. This makes it easier to spot an incorrect interpretation before it affects later analysis.

Troubleshooting

The dates still appear out of order. Check a few cells with Home > Number Format > General. If the displayed result is still text, the conversion did not work. Reopen Text to Columns and choose the correct source order, or use a helper conversion only when the text pattern is consistent. Also check that you did not sort by a different field in the Sort dialog.

Some dates converted to the wrong day or month. Undo the conversion if possible, or restore the original values from your saved copy. Repeat the conversion only after confirming the source’s date order. For example, selecting MDY for dates written DMY can swap the month and day. If a value is ambiguous and the source convention is unknown, find a reliable reference rather than guessing.

Excel sorts the first part of the list but leaves the rest unchanged. A completely blank row or column can make Excel treat one list as separate ranges. Remove unintended gaps or select the entire intended range before choosing Data > Sort. In the Sort dialog, inspect the range and make sure every record is included.

Dates and names no longer match. If you sorted only the date cells, immediately use Undo if no later edits have been made, then sort again with the entire dataset selected. If you cannot safely undo, restore the original workbook or use a backup; do not try to repair the alignment by sorting columns independently.

Some entries are blank or have errors. Check for empty cells, leading apostrophes, spaces, or error values mixed into the date column. Remove or correct these only after confirming what each entry should represent. If the dates came from another system, re-importing with the correct data type or locale may be safer than forcing a conversion in place.

The order within a day looks unexpected. The cells may contain date-and-time values, not dates alone. Excel sorts the full underlying value, including the time, so 9:00 AM comes before 3:00 PM on the same day in ascending order. If you want one group per calendar day, use a separate date-only field or decide how the times should be handled before sorting.

Frequently Asked Questions

Why does Excel sort dates alphabetically?

The values are probably stored as text, or the column mixes text and real dates. Convert the entries to actual Excel dates, confirm the results, and sort again.

How do I sort dates from newest to oldest?

Select a date cell and choose Data > Sort Newest to Oldest. For a multi-column list, use Data > Sort and set the date field’s order to Newest to Oldest so each complete row moves together.

Can I sort dates displayed as 01/02/2025?

Yes, if Excel stores them as real dates. The display format does not determine the underlying sort order. If they are text, first identify whether the source means January 2 or February 1, then convert using the matching date order.

Will sorting a date column keep the rest of each row together?

It will when you sort the complete data range or use a table’s header sort. If Excel asks whether to expand the selection, choose Expand the selection so related fields move with each date.

Why do dates on the same day sort differently?

The cells may include different times as well as dates. Excel sorts those full date-time values, so check the formula bar or format the cells to show the time before deciding whether the order is wrong.

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.