Use a helper column that formats that date nicer:

=text(a1,"mmdd")
drag down and sort your range by that column.

wrote:

Contact list in excel 2002, how do I sort birthday column by month then day.

--

Dave Peterson