Arrange Birthday List by MM/DD excluding YYYY

W

wendyg21

How do you arrange a column of birthdates so that the days are in an
ascending order? Excel automatically arranges it according to age. If
anyone knows, please help. I've tried about everything! Thanks.
 
N

Niek Otten

Insert a helper column. If the dates are in column A:

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

Now use that column as the sort key

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| How do you arrange a column of birthdates so that the days are in an
| ascending order? Excel automatically arranges it according to age. If
| anyone knows, please help. I've tried about everything! Thanks.
|
 
B

Bernard Liengme

Suppose a date is in A1
Use a helper column with:
=TEXT(MONTH(A1),"00")&TEXT(DAY(A1),"00")
This gives text in the form mmdd where mm and dd are digits
Copy down the column and sort on the helper column
best wishes
 
D

Debra Dalgleish

Or use: =TEXT(A1,"mmdd")

Bernard said:
Suppose a date is in A1
Use a helper column with:
=TEXT(MONTH(A1),"00")&TEXT(DAY(A1),"00")
This gives text in the form mmdd where mm and dd are digits
Copy down the column and sort on the helper column
best wishes
Click to expand...
 
Top