Grouping dates in a pivot table

[Fred Smith]

I have a table of bond maturity dates which I want to group by year.

When I create the pivot table, then try to Group the maturity date column, I get
the message "Cannot group that selection"

This normally happens if I have a non-date in the column of data, but I have
checked the data very carefully and am sure every cell is a valid date.

Is there anything else I can look for? If it means anything, the dates extend
out to 2053.

 

[Dave Peterson]

Any chance you included too many rows (and have an empty cell in that field)?

If you delete the existing pivottable and recreate it, does it work ok?

 

[Fred Smith]

Your reply pointed me in the right direction.

My data table actually contains entries for bonds, stocks, etc. I was using a
Page variable to select only the bonds. When I sorted the data by class, then
specified a pivot table range of only the bond entries, then it let me group the
maturity dates.

Now I just have to program this in VBA.

Thanks for your help.