how do i sort dates by months and not years?
 

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!

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.
"A Homeschool Mom" <A Homeschool 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!

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
XX

"A Homeschool Mom"
<A Homeschool
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!