Do you know how to sort by month (not year) in Excel?

Here's a super quick video on how to sort by month in Excel. Really useful if you're making a birthday calendar, but certainly not the only use for this.

Here are the formulas:

=text(C4, "MMDD")
=day(C4)
=month(C4)
=year(C4)

sort by month,excel,excel tutorial,sort by birthday,arrange by month,not year,organize by month,excel tricks,sort by date,custom sorting,ignore the year,extract year,extract month,extract day,