sort dates by day then month, not by year.

[Guest]

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

 

[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

 

[Guest]

Thank you so much that really helped.

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

 

[Bob Phillips]

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

That sorts by month then day

 

[KL]

Yeah, but I guess it is more logical viceversa

Regards,
KL

 

[Bob Phillips]

Agree with you, that is why I added my initial smiley

Regards

Bob