sort dates by day then month, not by year.

L

Lisa Peterson

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???
 
K

KL

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
 
L

Lisa Peterson

Thank you so much that really helped.

KL said:
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
Click to expand...
 
Top