How to Make Excel Sort Dates Correctly, Oldest First

Formulas & functions · Updated November 20, 2026

To make Excel sort dates correctly, first ensure the date cells contain real Excel dates rather than text, then select the entire table and choose Data > Sort Oldest to Newest or Data > Sort Newest to Oldest. If the order still looks wrong, convert text dates using Data > Text to Columns and select the correct date order for your regional format. These steps are for Excel for Microsoft 365 on Windows; Mac and web differences are noted below.

What You’ll Need

  • An Excel workbook with a date column and, if applicable, related information in the same rows.
  • A moment to check the date convention used in your data, such as month/day/year or day/month/year. This matters when dates are written with numbers only.
  • Permission to edit the workbook. If the information is important, save a copy before converting or rearranging data.

Step-by-Step

  1. Check that Excel recognizes the values as dates. Click a date cell and look at the formula bar. A real Excel date is stored as a number, even when it is displayed in a familiar format such as 3/14/2025. Changing a cell’s number format changes how that number appears; it does not turn text into a date. A useful clue is alignment: numbers and real dates are usually right-aligned by default, while text is usually left-aligned. This clue is not conclusive, because formatting or alignment may have been changed manually. Select a cell and temporarily choose Home > Number Format > General. If the value changes to a five-digit number, it is likely a real date; change the format back afterward. Excel dates use serial numbers, so earlier dates have smaller values.
  2. Make the date format consistent and confirm the regional order. Select the date cells, then choose Home > Number Format and pick Short Date or Long Date. You can also press Ctrl+1 on Windows to open Format Cells, choose the Number tab, then select Date and a suitable format. On Mac, use Command+1 to open Format Cells. This step makes real dates easier to read but does not fix text values. Before converting dates like 04/05/2025, confirm whether the source means April 5 or May 4. Ask whoever supplied the data or check other records; do not guess.
  3. Select the whole data range, not just the date column. Click a cell inside the table and, if Excel identifies the complete contiguous table correctly, proceed to sort. Otherwise select every column and row that belongs together, including headers if present. Sorting only the date column can separate dates from names, amounts, or other details in the same records. If prompted to expand the selection, choose Expand the selection. Avoid including unrelated notes or a separate table below the data. If your range has blank rows or columns splitting it, select the intended range manually so Excel does not stop at the gap.
  4. Sort using the date column. Open the Data tab. For a quick sort, click a date cell and choose Sort Oldest to Newest or Sort Newest to Oldest in the Sort & Filter group. If you selected a range with headers, Excel may ask whether the range has headers; confirm that it does if the first row contains column names. For more control, choose Data > Sort. In the Sort dialog, check My data has headers when appropriate, set Sort by to the date column, choose Cell Values, and select Oldest to Newest or Newest to Oldest. Click OK. The complete rows should move together in chronological order.
  5. Convert dates stored as text if the order is still incorrect. Make a backup copy first, especially if the workbook is shared or the original values need to be preserved. Select only the affected date cells, excluding the header. Go to Data > Text to Columns. In the wizard, choose Delimited and click Next, then click Next again without selecting delimiters. Under Column data format, choose Date and pick the order that matches the source values, such as MDY for month/day/year or DMY for day/month/year. Click Finish. This conversion can change how ambiguous values are interpreted, so verify several dates before sorting. Apply a date number format and repeat the sort. If the values contain extra words or inconsistent separators, clean those values first or use a carefully checked conversion method rather than converting blindly.
  6. Verify the result across the full range. Check the first few and last few records, plus dates around a year boundary or month boundary. For ascending order, dates should move forward from earlier to later; descending order should do the reverse. Confirm that the details in each row still match their original date. If the table uses filters, make sure no filter is hiding records that could make the order appear incomplete. Save the workbook once the sort and conversion look right.

Common Mistakes

Sorting by the text appearance instead of date values: Text entries may sort alphabetically or by their first characters. For example, text in a month/day/year pattern can put April dates before January dates because Excel is comparing characters, not calendar values. Convert the entries to real dates before sorting.

Sorting only one column: This can leave each date next to someone else’s name or amount. Always sort the complete table or accept Excel’s option to expand the selection. If the rows are already mismatched because a single column was sorted, use Undo immediately if possible, then redo the sort on the full range.

Assuming a date format fixes text: Selecting Short Date changes the display of date values, but text remains text. Convert the underlying values first. Similarly, manually changing alignment is not a conversion.

Choosing the wrong date order during conversion: MDY and DMY can interpret the same numeric string differently. A wrong choice may create valid dates that are nevertheless incorrect. Confirm the source convention before converting ambiguous dates.

Including a title row or unrelated data in the sort: A report title above the column headers can confuse Excel about where the table starts. Select the actual table and identify its header row in the Sort dialog. Keep separate data blocks out of the selection.

Tips

Use a consistent date format in the source data and avoid mixing entries such as 2025-03-14, 14/03/2025, and March 14, 2025 in one column. Consistency makes it easier to identify problems and reduces the risk of a locale-dependent conversion. ISO-style year-month-day values are often clear when exchanging data, but imported text still needs to be recognized as dates by Excel.

If you regularly add records, format the data as an Excel table with Home > Format as Table. Tables include filter buttons in their headers, and the date column’s filter menu can sort the table by date while keeping rows together. Confirm that the header row is correct when creating the table. A table does not automatically fix dates stored as text, so check new entries before relying on its sort.

For a one-time visual check, temporarily use a date format that includes the year, month, and day. This can expose records entered in an unexpected year or dates that look similar when the year is hidden. Restore the preferred display format after checking. Remember that changing a date’s display format does not change its chronological position.

When importing a CSV or data from another system, check the date column before doing extensive work. Import settings and regional conventions can affect how Excel reads dates. If you are unsure whether conversion will alter the values, duplicate the sheet or save a separate copy and test the process on a few representative rows first.

Troubleshooting

The dates remain in an unexpected order: Check whether they are stored as text by temporarily formatting sample cells as General. If they remain unchanged text, use Text to Columns with the correct MDY, DMY, or YMD choice. Then sort again. If the column mixes real dates and text, convert the text entries too; a mixed column can still produce an apparently broken order.

Some entries become incorrect after conversion: Stop and undo the conversion if you have not made other changes, or restore your backup. Confirm the original date convention and repeat on a copy with the right order selected. Values such as 13/04/2025 can help identify DMY data because 13 cannot be a month, but do not rely on that clue if the dataset contains no unambiguous dates.

Excel sorts dates but leaves blanks or unusual values at the ends: Check for empty cells, dashes, words such as N/A, or spaces in the column. These are not dates and may sort separately. Decide how those records should be handled, then remove or consistently label non-date entries before sorting. Do not replace missing dates with made-up dates just to force them into the sequence.

The sort changes the wrong rows or ignores some records: Check for blank rows or columns that divide the data, filters that hide records, and merged cells. Select the complete intended range manually and ensure each record occupies one row. Unmerge cells in the data area if necessary; merged cells can interfere with sorting.

You cannot find the same command: In Excel for Mac, use the Data tab and its sort controls or open the Sort dialog; labels and ribbon layout can differ slightly by release. In Excel for the web, select the range and use Data sorting controls, which may show ascending or descending labels rather than Oldest to Newest. The underlying requirement is the same: sort the full range by values that Excel recognizes as dates.

Frequently Asked Questions

Why does Excel sort my dates alphabetically?
If Excel treats the entries as text, it compares characters rather than date values. Convert them into real dates, check that the conversion uses the right regional order, and sort again.

Does changing Short Date fix dates stored as text?
No. A number format affects the display of real date values, not text. Convert the text values first, then apply Short Date or another preferred format.

Should I choose Oldest to Newest or Smallest to Largest?
For a date column, Oldest to Newest is the clearest choice. In a generic Sort dialog, Cell Values with Smallest to Largest also sorts real date serial values chronologically from earlier to later.

Can I sort dates in a filtered table?
Yes. Use the date column’s filter arrow or the Data sort controls. Excel sorts the table rows together, though active filters may hide some records from view. Clear filters if you need to inspect the complete sequence.

How do I keep new dates sorted automatically?
A normal sort does not guarantee that newly entered rows will stay in chronological order. Add the records to the table and sort the date column again when needed. Check that each new value is a real date before sorting.

Related

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.