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