Thank you so much that really helped.

"KL" wrote:

Hi Lisa,

You could...

1) create an additional column
2) enter the following formula in the first cell (e.g.B1) of the new column:

=TEXT(MONTH(A1),"00")&TEXT(DAY(A1),"00")

3) copy the formula down
4) sort using the new column

Regards,
KL

"Lisa Peterson" wrote in message
...
Is there anyway to sort birthdays by day then month not including the year
if
it is in this format: 01/05/50? I have tried auto filter, then custom
filter
but nothing works with that, so then I try to sort but it doesn't sort by
day
or month only the year. Can you please help me???