The only time I've failed to be able to group by dates is when there's something
in that field that isn't a date--either text or even an empty cell.

Any chance???

Shams wrote:

Folks,
I am trying to do a pivot table that will use the following data to first
sum the subtotal by Product and then Date. In this Case, I want Pivot to
Group by Date such as BA for January 2004 is 1,703.44. So, I am creating the
Pivot table selecting Product and Date under Rows and then summing by
subtotal. From my report, I try to right-mouse click on the Date field and
try to select Group. Excel comes back saying that it cannot Group that
selection. I am not sure why that's happening. My Date field is of the Date
format. Can somebody please help? Thanks.

DATE PRODUCT SUBTOTAL

1/1/2004 BA 256.36
1/9/2004 BA 369.36
1/15/2004 BA 482.36
1/29/2004 BA 595.36
3/15/2004 BA 708.36
6/15/2004 BA 821.36
12/31/2004 BA 934.36
1/16/2005 BA 1047.36
1/17/2005 BA 1160.36
1/18/2005 BA 1273.36
1/19/2005 BA 1386.36
03/15/2004 BH 123.36
06/15/2004 BH 123.36
09/15/2004 BH 365.36
1/23/2005 BH 1499.36
2/22/2005 BH 1612.36
3/29/2005 BH 1725.36
5/15/2005 BH 1838.36

--

Dave Peterson