If Excel can recognize the values as dates, you'll get the grouping optons.

Post a sample of your "dates". Perhaps we'll spot an issue.


***********
Regards,
Ron

XL2003, WinXP


"Marion" wrote:

I am working in a pivot table, dragged my dates in from source data and want
to group, it gives me error message " cannout group selection". I took out
all blanks. Will not even give me the option to choose month, year,etc.