Hi,

Make sure you have no blank rows in your Pivotdata range, and that you
have no blank cells in your date range. The data grouping wont work in
those cases.

Regards

Govind.

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?