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

S

Shebamandy

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

Marcelo

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:
 
B

Bob Phillips

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)
 

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

Sorting dates, ignoring year 3
Add 2 days before and after birthdate 4
Sort by Date Function 3
Modern equivalent of Autotext in Word? 0
Date / month / year 1
find out specific month and year 1
sorting by date 3
How do I calculate age from birthdate to present in Excel? 4

Top