Excel: Sort by Month and Day

 

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