Arrange Birthday List by MM/DD excluding YYYY

  • Thread starter Thread starter wendyg21
  • Start date Start date
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.
 
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.
|
 
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
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to enter a date in DD-MM-YYYY format 2
Getting MM-DD HH:MM out of Julian date 4
Arranging dates in a single column 5
Converting MM/DD/YYYY into just MM/DD and Sorting 1
Day of Week from dd/mm/yyyy 7
Change MM/DD/YYYY to MM/DD/YY 5
making age group query work 7
How to convert mm/dd/yyyy date format to yyyy-mm-dd 3

Back
Top