Why are Excel dates not sorted correctly?
Braxorn · Last updated 2026-11-22 · English
If some of the cells that look like dates are stored as text, the sorting gives unexpected results. Additionally, the day/month order can be misinterpreted in data from different sources.
What can you do?
- Examine whether the cell is an actual date value or text; Do not rely on the display format alone.
- Determine the day/month/year order of the source data and make the conversion according to this order.
- Try the conversion in the auxiliary column and compare especially uncertain dates one by one.
A small example
03/04/2026 may mean 3 April in one source and 4 March in another source. Incorrect conversion may not produce an error message because both are valid dates.
What to watch for
Choosing a date-only format does not convert the current text to a date in all cases. Two-digit year and region settings should also be checked.
Check the result
Verify the order with examples containing the first and last days of the same month.
Examples are synthetic. Formulas use English function names and comma separators; names or separators may differ with your Excel language and regional settings. Menus and features vary by version.
Microsoft source (English)
Review your own workbook
You can start reviewing your Excel file in Braxorn. Check which controls are supported and review incomplete checks alongside the report scope.
Review your file