Grouping dates in a pivot table
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.
--
Regards,
Fred
|