That sounds great, but I dont want that helper column showing since it will
not make sense.

"CLR" wrote:

You could use a helper column with =YEAR(A1) copied down and do the primary
sort on that column.

Vaya con Dios,
Chuck, CABGx3



"Marilyn" wrote:

I have a columns with dates in Excel 2003 and I want to sort them by Year,
but it does not seem to be happening. Am I missing something?

Thanks,