Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tell me which "season" (Month/Day through Month/Day) a date(Month/Day/Year) falls in (any year)??? | Excel Discussion (Misc queries) | |||
I want to sort by month, date, year. Birthdates. How do I do it | Excel Worksheet Functions | |||
Sort month/date/year data using month and date only | Excel Discussion (Misc queries) | |||
Sort by Month and Year | Excel Discussion (Misc queries) | |||
How do I sort dates by month rather than by year? | Excel Discussion (Misc queries) |