Use

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

otherwise it will sort incorrectly

--
HTH

Bob Phillips

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

"Marcelo" wrote in message
...
Hi,

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

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Shebamandy" escreveu:

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