sort on a date

L

LuluD

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.
 
M

Marcelo

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:
 
Top