Fred,
Yes, I did create a pivot table and then tried to group them by months, but
got an error message that it could not do so.
Part of the problem could be the date field. I have trouble discerning what
the field is truly formatted as and if in fact Excel sees it as text or date.
Any tips on that would be helpful.
Tx
Rocky

"Fred Smith" wrote:

Have you created the pivot table? If your column of data has only dates in it,
Excel should automatically group them by months. What part of the pivot table
are you having problems with?

--
Regards,
Fred


"Rocky" wrote in message
...
My worksheet has dates in the "mmddyyyy" format with associated counts of
procedures. I would like to present this in a pivot table with the counts
broken down by months and formatted as "Jan, Feb, etc."
How to do it?
Tx
Rocky