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

Learn 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!

Don’t miss out a great opportunity to learn:

How to Sort and Filter in Excel

===============

❤️ Become a Patron:
Do you find our tutorials useful? Join this channel and become a patron

===============

⏱️Timestamps⏱️
0:00 Intro
0:29 How to Format the Column Containing the Dates as ‘Date’
0:37 How to Sort by Date in Excel - ‘Oldest to Newest’
1:27 How to Sort by Date in Excel - ‘Newest’ to Oldest’

================

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! :)

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

Got Microsoft Office 365? Get it here

Connect:

Screen Recorder & Video Editor:

#MicrosoftExcelTutorial #ExcelQuickAndEasy #EasyClickAcademy

[Matt-wfry]

I did all the steps but the option to sort by oldest to newest or newest to oldest isn't there. What can I do?

[samclarke]

Hi, I have a problem. sort oldest to newest isn't an option. It just says sort "A to Z" or "Z to A". How do I get it to show me the option "oldest to newest"? Thanks in advance

[michaelmclachlan]

I'd like to see you take this one step further. Imagine you have a list of dates, all in the same month but different days and years. A list of employees with hire dates would be a good example. I'd like to know how to sort for the day of the month so I could easily whose hire "day anniversary" is coming up next.

[squidly]

Can't figure out how to sort Dates. The only option are "A to Z" which only sorts by the first date numbers e.g 6/17/2022 but not by year 6/16/2023.

[bulldogkarma]

Oddly, my dates column is indeed labeled as dates, but when I want to sort, it only wants to sort from A to Z and not Newest to Oldest.

[patrickparsad]

I love you for this video you are a big help mam 💞😭

[noel]

Thanks for the video it was really helpful 👏🏻❤️

[miafojasloyola]

Thank you, concise and easy to follow.

[HeritagePrimary]

Thank you so much it was really helpful

[nightrider]

Thank you vey much. thank you thank you ❤ this will want to my exam ❤

[rohitshah]

Thanks for the help. As a thank you I gave you a like.

[anshverma]

Thank you it helped ! I just selected all the columns and it worked

[ldee]

Thank you very much that was really helpful well explained.😘

[Waxeed]

is there a way to make this automated ( every time i change the date it will keep the original and add new column with the new date and auto sort it? )

[samimpathan]

I like your video thanks for learning us

[Indigo-]

How can I automate this so if I were to add a couple new rows at the bottom it will automatically sort by my chosen column? Or do I have to repeat the process manually?

[TheSuperstar]

I was kinda looking for something more advanced really... thought you would have used the sort formula.

[dhuratadobbins]

My option isn't giving me a 'Oldest to Newest' or 'Newest to Oldest'