sorting dates!!!!help appreciated!!

[brenijb]

i am trying to sort birthday dates (month/day/year) by only the month and then day. excel keeps sorting the by the year. i dont even need the year in the cells, but i cant seem to remove them. if i format the cell to only give me the month and day, that does not work because when you click on the actual cell. the month day and year are in the formula bar. my info is like as follows:

tim 11/1/1939
jon 9/13/1940
sara 7/1/1980

sorting puts it in order of the year. i want it to look like:

7/1/1980
9/13/1939
11/1/1940

text to column does not seperate the year out either, or maybe there is a way to remove the year?

please help

 

[Greg Truby]

Create a helper column with the formula <ul>[*]=DATE(1900,MONTH(A1),DAY(A1))[/list] and sort by that, then delete (or hide) the helper column.

{edit}forgot my manners -- welcome to the board! {/edit}

 

[brenijb]

thankyou sooooooo much! i would think that there would be an easier way to do it with a simple one touch click, but oh well. thanks!!

Brenijb