Hi, it's been a while since I worked, and am rusty, our membership list has birthdays including year, all in one column, (I inherited it as it was and want to leave it easy if I can). I too would like to sort on Month and then Day, ignoring the year. But keep the year shown with birthday as it is relevant, I don't recall how to do what the top answers are doing. Is the one with the formula, the way I must format the column? I am confused. Sorry