On Mon, 11 Feb 2013 14:50:38 +0000, AuditorLisa wrote:

I'm not sure why but it is not allowing me to "Group" when I right click
a date in the pivot table. I had tried the approach before and ran into
the same problem. I'm wondering if it is because the date is followed by
"Count" since I previously subtotaled a larger sheet to extract this
data? Would you have any suggestions as to how to make the grouping
function work?

In order to group a column of dates in a pivot table, all of the entries in that column must be dates. If there are any text entries in the column, or dates that happen to be text rather than dates, you will not be able to group them.

You will need to clean up your data; perhaps you could just remove the subtotals, or filter them out.