Sorting Birthdate help

[SFD]

I have a spreadsheet that lists birthdays in one cell, last name in another
cell and first names in another cell.

I am trying to sort this list by month of birth, I have tried
data>sort>options>Jan,Feb ect.... and it will not sort by month.

Any suggestions are appreciated.

Thanks
Steve

 

[Dave R.]

This question has come up recently. If I remember right, people suggested
creating a "helper" column with the formula =MONTH(cellcontainingbirthdate)
and then sorting by this column.

You can also use something like this;

=DATE(2004,MONTH(A1),DAY(A1))

as the formula in the helper column, if you want to put them in order of day
of the month also.

 

[S.C]

Thanks Lance,

That was what I needed

You can create a new column with Month(C1) where column c has the birthdate and
sort on that column.

Note:Be sure to back up before sorting