1. In the adjacent blank cell of the dates, in this case, in cell C1, enter the formula =TEXT(B1,"MMDD"). My first birthdate is in cell, B1. Yours might be in another cell.
2. Press the Enter key. Select cell C2, then drag the autofill "+" down the column to populate the formula for all the rows.
3. Click on the little arrow on the right side of the new column and Sort Sheet A - Z using this column.
4. Delete the "sort" column. (You no longer need it!)
5. You are done! The birthdays are sorted by month and day with no regard to the year.
