Excel dates will not sort correctly: check text values before changing the format

Check the values before sorting again

Save a copy before changing anything. Include the whole record in your inspection: a deadline, project name, and invoice number must still refer to the same row after sorting.

Identify the failing group

Look at a few rows near the point where the order goes wrong. Did they come from a different export, use a different month/day convention, or arrive through copy and paste? Use an untouched source to confirm what the dates mean.

For a candidate date in A2, enter =ISNUMBER(A2) and =ISTEXT(A2) in two unused cells. Microsoft's IS-function reference explains that these checks inspect the stored value without converting numeric-looking text.

A numeric result is not proof of the correct calendar date. Compare it with the source, especially where month and day can be confused.

Microsoft states that chronological sorting requires dates stored as date serial numbers. Its sorting guide also warns that sorting an isolated part of a larger range can separate it from related data.

Avoid sorting only the date cells. Select the complete record range, or work within an Excel table. In Windows desktop Excel, use Data → Sort, choose the date column and the oldest-to-newest order, and verify that the header setting matches your data. If prompted about adjacent data, include the related columns.

Convert a small sample in a helper column

For a text date in A2, enter =DATEVALUE(A2) in an unused column. Apply a date number format to the result so that you can inspect it. Microsoft's text-date conversion guide covers this helper-column approach.

Try several representative rows before filling down. If the result is wrong or shows an error, leave the original intact. A successful calculation alone does not prove that the intended date was understood.

Check ambiguous dates and timestamps

The text 04/05/2026 is ambiguous without a known date convention. Confirm its meaning with the system that generated the file before accepting a conversion. Microsoft's DATEVALUE reference notes that system date settings influence interpretation.

DATEVALUE also ignores time information. Do not use it alone to rebuild a column in which the order of events within a day matters. A missing year is another reason to stop: the function can supply the current year, which may be wrong for archived records.

After checking the helper results, sort the complete copied dataset by that column. Compare several project/date pairs against the untouched workbook, including the earliest and latest records. Keep the source column until that comparison is complete.

If the result still looks wrong

Record whether the problem appears in desktop Excel, the web version, or both. Prepare a small, anonymized workbook with the original strings and expected dates, then use Microsoft Support through the linked documentation. For organization-managed files, ask the owner about the export's regional convention before changing shared data.