Sorting by month, disregarding the year

S

Soffi

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 ?
 
B

Bob Phillips

In a helper column, add a formula of

=MONTH(B2)

copy down, and sort by the helper column.
 
M

Myrna Larson

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

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