How to Sort Dates By Month and Day Only on Excel

There may be times when you want to sort dates by month and day while ignoring the year. For example, if you want to group anniversary dates such as clients, birthdays, etc.

By default, when you sort dates in a column, they are sorted by year, month, and day. If there are dates from multiple years and you want your data arranged by month instead while disregarding the year, there is no obvious solution.

Here's the work-around solution I use. There are are other ways to do this (as is the case with most things in Excel) but this one is quick and simple:

Insert a blank column next to your Date column.
Assuming your first date is in cell A4, in the blank column, enter the formula: =TEXT(A4,"MMDD")
Copy this formula down to the bottom of your data.
Sort your data on this column.

[kouroshk]

IVE BEEN TRYING TO DO THIS FOR 3 HOURS !! THANK YOU WISH I FOUND THIS VIDEO EARLIER

[SavageMango]

ah yes, my boss wanted exactly how this looks like(only sorting months and days), and I even looked up a lot of guides on how to do it. But guess what, all were not working until I stumbled upon this video. Thanks man❤

[rahmanzahid]

Thank you so much. Clear, concise & direct to the point. Wish all tutorial can be like this.

[bontanae]

Thank you so much! I've been searching for a solution!

[lisawhite]

This is exactly what I needed - thank you so much!!!!

[nadishak]

Thank you greatly. Just what I needed to do.

[sejalpatel]

Wowww, thank you so much. It helps a lot

[samonugae]

Thanks a lot and God bless you. This is really awesome.