in a pivot table

[kathyre26]

while trying to group datesby quarters, I select a date, choose group, i get
"cannot group that selection" message. I cannot figure out why that might
be.

 

[scott]

Check the format of the cells to make sure that they are formatted as dates.

 

[Debra Dalgleish]

That error can occur if there are blank cells or cells with text in the
date column. There are some suggestions here for fixing the problem:

http://www.contextures.com/xlPivot07.html#Problems