Winnie

In an adjacent column enter = MONTH(A1).

Copy down then sort on that column.


Gord Dibben Excel MVP

On Fri, 14 Oct 2005 10:18:02 -0700, Winnie
wrote:

I try to sort the list of date by Month. But Excel only can sort by year.