Why are my dates not sorting correctly in Excel?

The dates are likely stored as text. Convert them to real dates before sorting.

How do I sort newest to oldest in Excel?

Select a date cell and choose Data > Sort Newest to Oldest.

Use it on one real task this week, then add a sticky note on your monitor with the shortcut until it becomes automatic.

Most shortcuts differ slightly on Mac (Cmd instead of Ctrl). Check the function or feature page for platform notes when something does not work.

Tips & Tricks - 2026-05-12

Learn how to sort dates in Excel, fix dates stored as text, sort by month, newest to oldest, oldest to newest, and custom date groups.

Excel can sort real dates chronologically because dates are stored as serial numbers. If sorting looks wrong, the dates may be stored as text.

Click a date cell, then use: Data -> Sort Oldest to Newest Use this for timelines, due dates, and transaction history.

Use: Data -> Sort Newest to Oldest This is common for recent orders, latest updates, and newest activity.

If Excel sorts dates alphabetically, convert them to real dates. Text to Columns can often fix imported dates. Check that date filters appear in the filter menu; if they do not, Excel may not recognize the values as dates.

Excel Date Formulas Text to Columns in Excel How to Sort in Excel How to Filter in Excel

Try the shortcut or setting on a copy of your file first. Pin the technique to your Quick Access Toolbar if you will use it daily. Pair productivity tips with Excel Tables and named ranges for fewer broken references. Explore: Tips archive · Keyboard shortcuts guide

Why are my dates not sorting correctly in Excel? The dates are likely stored as text. Convert them to real dates before sorting.
How do I sort newest to oldest in Excel? Select a date cell and choose Data > Sort Newest to Oldest.
How do I remember this Excel tip? Use it on one real task this week, then add a sticky note on your monitor with the shortcut until it becomes automatic.
Will this tip work on Mac Excel? Most shortcuts differ slightly on Mac (Cmd instead of Ctrl). Check the function or feature page for platform notes when something does not work.