Thread: sort on a date
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Marcelo
 
Posts: n/a
Default sort on a date

Hi,

use an auxiliar column to do it, assuming that your date list is on column A
on column b use:

=year(a1)

copy it down, sort by column B, and delete it if is the case


hth
regards from Brazil
Marcelo

"LuluD" escreveu:

How to sort on a column of dates - for example
03/30/2005
I want to sort on the year, not the month and day.
Thank you.