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.
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.
Sort & Filter sorting options
Dates sorted Oldest to Newest (ascending order)
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.