how do i sort dates by months and not years?

[A Homeschool Mom]

I have two columns. One with dates and one with names:

09/22/77 Jane Doe

I'm trying to sort these by months so I can keep track of people's
birthdays. Is there a way to do that?

Thanks!

 

[Alan]

One way, in a third adjacent column enter =MONTH{A1) assuming the date is in
column A then sort the range by that column,
Regards,
Alan.

 

[Jim Cone]

AHM,

My "Special Sort" Excel add-in will do that, plus it has 11 other ways to sort.
(even by cell or font color)

Comes with a Word.doc install/use file.
Free upon direct request - remove XXX from my email address.

Jim Cone
San Francisco, USA
(e-mail address removed)

"A Homeschool Mom"
<A Homeschool (e-mail address removed)>
wrote in message
I have two columns. One with dates and one with names:
09/22/77 Jane Doe
I'm trying to sort these by months so I can keep track of people's
birthdays. Is there a way to do that?
Thanks!