Sorting

[scAle_up]

I want to sort a list using day of birth, it is all the same month but different years. How do I go about it?

[#2 · Accepted solution]

@scAle_up 

Let's say the birth dates are in D2:D100.

Insert a column to the right of column D. Enter the following formula in E2, then fill down:

=TEXT(D2, "mmdd")

Sort the entire range on column E.

[#3]

Great! Thanks.