Sort by date month and not year

  • Thread starter Thread starter Visha
  • Start date Start date
V

Visha

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.
 
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.
 
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.
 
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!
 
Or if you want to sort by month and day, but not year, use =TEXT(A1,"mm/dd")
and sort by that column.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sort by date but not year 4
Problem sorting by date after 2029 on Excel 2003 1
how do I sort dates by months? 2
Separating dates from one column to Month, Date, Year columns 2
Sorting a date by month, date and then year. 2
Sort month/date/year data using month and date only 6
Sorting date fields by month excluding year 1
Date Conversion 4

Back
Top