I'd use a helper column with a formula like:

=text(a1,"mm-yyyy")
or
=text(a1,"yyyy-mm")

sort by month then year (or by year, then month???).

Charles wrote:

I often need to sort a worksheet by month first then by one or two other
columns, my problem is that excel takes the day of the month into account. Is
it possible to do this sort only by the month and year only and ignoring the
day of the month? BTW I would prefer not using a pivot table.

--

Dave Peterson