View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default How do I sort birthdays?

You should be able to just sort by the date -- if those values are really dates.

On the other hand, if you wanted to sort by month (all January together no
matter the year), I'd use a helper column with:

=text(a2,"mmddyyyy")
drag down

And sort by this helper column.


Lois wrote:

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


--

Dave Peterson