Thread: I want to sort by month, date, year. Birthdates. How do I do it
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo Marcelo is offline
external usenet poster
  
Posts: 1,047
Default 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.

Reply With QuoteReply With Quote