Sort by date month and not year
 

I am trying to sort a list by date month, not year, but the data is in
mm/dd/yy format from the original list. I need to make a birthday list and
the list is too long to cut and paste individual (over 800 entries). Please
help I've tried every thing I can think of including the options in sort, it
just places it in Month order with the year and we have people ranging from
born in 1930-1999. So this is not helpful at all.

Sort by date month and not year
 

Just sort by month? if so put a formula in another cell =MONTH(A1) and copy
it down. This will get the month number of the date, then sort my this column.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Visha" wrote:

I am trying to sort a list by date month, not year, but the data is in
mm/dd/yy format from the original list. I need to make a birthday list and
the list is too long to cut and paste individual (over 800 entries). Please
help I've tried every thing I can think of including the options in sort, it
just places it in Month order with the year and we have people ranging from
born in 1930-1999. So this is not helpful at all.

Sort by date month and not year
 

Use a spare column with the formula
=MONTH(A1)
in the first cell (replace A1 by the cell where the date is), copied down as
far as your data. Then you can sort by this column independently of the
year.

"Visha" wrote in message
...
I am trying to sort a list by date month, not year, but the data is in
mm/dd/yy format from the original list. I need to make a birthday list and
the list is too long to cut and paste individual (over 800 entries).
Please
help I've tried every thing I can think of including the options in sort,
it
just places it in Month order with the year and we have people ranging
from
born in 1930-1999. So this is not helpful at all.

Sort by date month and not year
 

It worked like a charm!!! Thanks, this has been a problem for quite some time
and usually I would just take a whole day to cut and paste. Thanks so much!
Have a happy holiday!

"Visha" wrote:

I am trying to sort a list by date month, not year, but the data is in
mm/dd/yy format from the original list. I need to make a birthday list and
the list is too long to cut and paste individual (over 800 entries). Please
help I've tried every thing I can think of including the options in sort, it
just places it in Month order with the year and we have people ranging from
born in 1930-1999. So this is not helpful at all.

Sort by date month and not year
 

Or if you want to sort by month and day, but not year, use =TEXT(A1,"mm/dd")
and sort by that column.
--
David Biddulph

"John Bundy" (remove) wrote in message
...
Just sort by month? if so put a formula in another cell =MONTH(A1) and
copy
it down. This will get the month number of the date, then sort my this
column.

"Visha" wrote:

I am trying to sort a list by date month, not year, but the data is in
mm/dd/yy format from the original list. I need to make a birthday list
and
the list is too long to cut and paste individual (over 800 entries).
Please
help I've tried every thing I can think of including the options in sort,
it
just places it in Month order with the year and we have people ranging
from
born in 1930-1999. So this is not helpful at all.