New Contributor

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 Replies
best response confirmed by scAle_up (New Contributor)


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.

Great! Thanks.