View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith
 
Posts: n/a
Default 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