I am getting the same error. I've reformatted the dates various ways and I
get get my spreadsheet to group by quarters. I've tried rearranging my pivot
table, removed any blanks, etc. I've never had a problem like this come up
before. ANy suggestions?

"Johnson748r" wrote:

I am trying to group some dates in a pivot table, however when I select the
field, right click and select "group", I get an error - "Can't group that
selection". I have checked that the field is formatted correctly (dates). Any
suggestions?