I want to sort by month, date, year. Birthdates. How do I do it

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Shebamandy - 17 Oct 2006 16:25 GMT

I want to list our Departments birthdates. By month, date and year would be
there but I don't want it sorted by year.

Reply to this Message

Marcelo - 17 Oct 2006 16:32 GMT

Hi,

in an auxiliar column use =month(a2)&day(a2)&year(a2)
copy it donw and sort using this column

hth

Signature

regards from Brazil
Thanks in advance for your feedback.
Marcelo

> I want to list our Departments birthdates. By month, date and year would be
> there but I don't want it sorted by year.

Reply to this Message

Bob Phillips - 17 Oct 2006 16:52 GMT

Use

=TEXT(MONTH(A2),"00")&TEXT(DAY(A2),"00")&YEAR(A2)

otherwise it will sort incorrectly

Signature

HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

> Hi,
>
[quoted text clipped - 5 lines]
> > I want to list our Departments birthdates. By month, date and year would be
> > there but I don't want it sorted by year.

Reply to this Message