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" <Soffi@discussions.microsoft.com> wrote in message
news:FD1B63BC-9DE5-4C73-A694-19077D772598@microsoft.com...
> 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"
<bob.phillips@notheretiscali.co.uk> 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"
> <bob.phillips@notheretiscali.co.uk> 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