How to Sort by Date in Excel (in a Quick and Convenient Way)

How to Sort by Date in Excel

Today we’ll be talking about how to sort by date in Excel. We’ll go through a quick and convenient way how to sort dates in a table starting with the oldest or the latest one.

Well, here we go!

Would you rather watch this tutorial? Click the play button below!

How to Format the Column Containing the Dates as ‘Date’

To sort by date in Excel, first we need to make sure that the column containing the dates has been formatted as ‘Date’.

How to Sort by Date in Excel - the column containing the dates has been formatted as ‘Date’

How to Sort by Date in Excel – ‘Oldest to Newest’

Then we select the whole area which we want to sort, header including.

How to Sort by Date in Excel - select the whole area including header

Once we’ve selected the area, we go to the Data tab and click on ‘Sort’.

How to Sort by Date in Excel - go to the Data tab and click on ‘Sort’

A pop-up window appears where we can set necessary details.

How to Sort by Date in Excel - A pop-up window appears

Since we’ve included the header, we’ll keep the option ‘My data has headers’ selected.

How to Sort by Date in Excel - keep the option ‘My data has headers’ selected

With this we’ll make sure that the names of the column headers from the table will be displayed in the ‘Sort by’ drop-down list.

How to Sort by Date in Excel - the names of the column headers from the table will be displayed in the ‘Sort by’ drop-down list

Here we want to sort by ‘Date of Birth’, so we’ll select this option and move on to the next step.

How to Sort by Date in Excel - select the option sort by ‘Date of Birth’

Now, in the section ‘Order’, we can choose which way we want to sort the dates – ‘Oldest to Newest’ or ‘Newest to Oldest’.

How to Sort by Date in Excel - choose which way we want to sort the dates

Let’s click on ‘Oldest to Newest’ and confirm with OK.

How to Sort by Date in Excel - click on ‘Oldest to Newest’ and confirm with OK

As you can see, all the dates have now been sorted, starting with the oldest one – just as we wanted.

How to Sort by Date in Excel - all the dates have now been sorted, starting with the oldest one

How to Sort by Date in Excel – ‘Newest’ to Oldest’

If you need to sort the dates the other way round, you can follow the same procedure, just select the option ‘Newest to Oldest’ in the last step.

How to Sort by Date in Excel - select the option ‘Newest to Oldest’ in the last step.
How to Sort by Date in Excel - sorted ‘Newest to Oldest’

To have a closer look at other possibilities to sort in Excel, check out more tutorials by EasyClick Academy! The links are included in the list below.

Don’t miss out a great opportunity to learn:

If you found this tutorial helpful, give us a like and watch other tutorials by EasyClick Academy. Learn how to use Excel in a quick and easy way!

Is this your first time on EasyClick? We’ll be more than happy to welcome you in our online community. Hit that Subscribe button and join the EasyClickers!

Thanks for watching and I’ll see you in the next tutorial!

Comments

Add comment

Your email address will not be published.

Your personal information will only be used for the purpose of processing this comment.

This site uses Akismet to reduce spam. Learn how your comment data is processed.