sort employees by birth month?

Hi All,
Been trying and trying, I have a list of employees in col A, their date of birth in col B, I'm trying o sort these by the month on birth - Jan - Dec.

All the employees born in Jan would be sorted first, then Feb, then Mar,
etc...etc...etc

How can I work this? Is there a macro I can run to re-sort this later (new employees get hired on, or leave)?

Thanx...LT

hi,

highlight column a and b that goto> data>sort> select column b

hope this helps

steve

Hi...tried that, it sorts by the year - not by month of birth.
Trying to sort a list of over 500 employees by month of birth.
All who were born in Jan, then Feb, then Mar....etc...etc

hi,

could you not put this in a helper column

=MONTH(A1)

then sort on that

steve

Yeah that worked, after sorting, I used a white font color for that column so it wouldn't print those characters.

Thanx for the tip.

Lt