PivotTable question - date format

C

-= cj =-

Thanks Debra,

For some reason when on that Date field button in the
Pivot table & choose the Group & Show Detail > Group
I get a "Cannot group that selection" pop up message.

I'll give the other tips a shot, I'm sure those will work.
thanks again
 
D

Debra Dalgleish

If the date column contains text, or blank cells, you'll see that
message. Maybe you included some blank rows at the end of the source
data range.
 
Top