Why aren't dates always available to group in pivot tables?

[Guest]

I download data that gives me sales number by individual day. I build a
pivot table to get total sales by day and then group the process day by month
or quarter. Sometimes this works perfectly, while other times I get the
message 'Cannot group that selection'. Has this happened to anyone else? Is
there a limit to the number of rows or columns that can be grouped?

 

[Debra Dalgleish]

You'll see that error message if the date field contains a blank cell,
or text entry. There's a bit more information, and some workarounds, here:

http://www.contextures.com/xlPivot07.html#Problems

 

[Ken Wright]

You cannot have any blanks, text, or non date entries in a date field if you
want to be able to group the dates.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission
------------------------------­------------------------------­----------------

 

[Debra Dalgleish]

After restoring the dates in the source data, remove the date field from
the pivot table
Refresh the pivot table
Add the date field to the pivot table, and you should be able to group
the dates.