Sort Date column by month not year


Posted by Helen on August 30, 2001 10:14 AM

I have a column of birthday dates formatted as 02/11/66,
I want to sort in month order so the spreadsheet starts with the Januarys
and ends with the Decembers.
I had no luck with Data/Sort/Options/First Key Sort order.
It still had them in oldest to youngest.

Am I missing something?
thanks in advance



Posted by Barrie Davidson on August 30, 2001 10:37 AM

Helen, use this formula in an adjacent column and then sort on that column.

=Month(A1)

Barrie