Sort by dates

When dates in a worksheet are not in order, you can sort them, as in the example below. Use the same steps to change the sort order, for example, from oldest on top to newest on top.

Unsorted dates in a worksheet

Unsorted dates

To sort dates, drag down the column to select the dates you want to sort.

Then, on the Home tab, click the arrow under Sort & Filter, and click either Sort Oldest to Newest, or Sort Newest to Oldest.

The Sort & Filter button on the Home  tab

Sort & Filter sorting options

Dates sorted Oldest to Newest

Dates sorted Oldest to Newest (ascending order)

Dates sorted Newest to Oldest

Dates sorted Newest to Oldest (descending order)

 Note    If the results are not what you expected, the column might contain dates stored as text instead of as dates. Convert dates stored as text to dates shows you what to do if this should happen in your worksheet.

Give it a try

If you want to play around with sorting dates, here's some sample data.

In this embedded workbook, click the arrow in cell A1 to sort dates earliest to latest, or latest to earliest.

You can download this workbook to your computer, and then open in Excel. Just click the Excel icon on the lower-right corner of the file, save the file to a convenient place on your computer, and then open it.

Applies to:
Excel 2013