Sorting by month, disregarding the year
 

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 ?

In a helper column, add a formula of

=MONTH(B2)

copy down, and sort by the helper column.

--
HTH

Bob Phillips

"Soffi" wrote in message
...
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 ?

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

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


On Mon, 26 Sep 2005 09:01:18 +0100, "Bob Phillips"
wrote:

In a helper column, add a formula of

=MONTH(B2)

copy down, and sort by the helper column.

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

Myrna Larson wrote:
Or, if you want to sort by month and DAY, make the formula

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


On Mon, 26 Sep 2005 09:01:18 +0100, "Bob Phillips"
wrote:


In a helper column, add a formula of

=MONTH(B2)

copy down, and sort by the helper column.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html