Heather,

I don't understand. If you simply sort the dates then all January (etc) will
end up together. The only time this wouldn't be the case is for (say)
January's in different years but your sample data doesn't show that. Are you
saying you want all the same month together irrespective of the year?

If so use a helper column with the month in and sort on that

=MONTH(A1)

Mike

Mike

"HeatherJ" wrote:

I recently updated to Excel 2007 and can't figure out how to perform a
function I used to on my old version of excel.

I have a column of dates: 01/02/2009
01/13/2009
02/07/2009
02/19/2009
I want to sort by month, not by dates within a month. I used to format the
cell to show the date as "January" or "February."

Then I would use the Data-Text to Columns function and click column type
"Text." That would change the contents of the cell to January, February,
etc.

This allowed me to easily subtotal by month.

How can I do this in Excel 2007?

Thank you,
Heather