Sorting by month, disregarding the year

[Guest]

I have a list of names in one column, and their date of birth in another
column.
I want to sort day and month, disregarding the year, in order to see who has
a birthday this month. But how ?

 

[Bob Phillips]

In a helper column, add a formula of

=MONTH(B2)

copy down, and sort by the helper column.

 

[Myrna Larson]

Or, if you want to sort by month and DAY, make the formula

=MONTH(B2)*100+DAY(B2)

 

[Debra Dalgleish]

Or: =TEXT(B2,"mm-dd")

Or, if you want to sort by month and DAY, make the formula

=MONTH(B2)*100+DAY(B2)