View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default How do I sort birthdays?

Hi,

you can use an auxiliar column with this formula =year(a2), copy it down,
sort by this column.

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



"Lois" escreveu:

I would like to sort the birthdays to put in order for the year