# Sorting by month, disregarding the year

1. ## 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 ?

2. ## Re: Sorting by month, disregarding the year

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 ?

3. ## Re: Sorting by month, disregarding the year

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.

4. ## Re: Sorting by month, disregarding the year

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

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1