Check that there are true date values in the complete column of data that is
being pivoted.
PT doesn't group if cells are blank.

--
Regards

Roger Govier


"rmm30" wrote in
message ...

It says can not group that selection. any thoughts?


--
rmm30


------------------------------------------------------------------------
rmm30's Profile:
http://www.excelforum.com/member.php...fo&userid=8358
View this thread: http://www.excelforum.com/showthread...hreadid=390130