Sorting by date

Hi Liz

Thank you for your question. One thing you might want to try is to create a new blank workbook then create three dates in a column and test the sort feature (Data > Sort) to make sure you get the results you expect.

If that works then we know Excel is behaving as expected we just need to track down the problem in your work book. Click on one of the cells that contains a date. Press F2 on your keyboard and check the very beginning of the date value. Is there an apostrophe ' right at the start of the date? The apostrophe tells Excel to treat the contents of the cell as text even if you have applied a different format to the cell.

Let me know how you get on.

Kind regards,

Andrew