Arrange Birthday List by MM/DD excluding YYYY

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

wendyg21 - 03 Nov 2006 18:54 GMT

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.

Reply to this Message

Niek Otten - 03 Nov 2006 19:43 GMT

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

Signature

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.

Reply to this Message

Bernard Liengme - 03 Nov 2006 19:46 GMT

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

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

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

Reply to this Message

Debra Dalgleish - 04 Nov 2006 01:47 GMT

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

> 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

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply to this Message