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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - I want to sort by month, date, year. Birthdates. How do I do it (https://www.excelbanter.com/excel-worksheet-functions/114794-i-want-sort-month-date-year-birthdates-how-do-i-do.html)

Shebamandy

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

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

Marcelo

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

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.

Bob Phillips

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

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.

All times are GMT +1. The time now is 01:00 PM.