It might be easier to do this to convert the text to dates:

Select the range
edit|replace
what: / (slash)
with: / (slash)
replace all

Excel will see it as a date. Make sure the date is in the same format (mdy or
dmy) as your short date format for your pc.

Another way is to select the range
data|text to columns
choose fixed width
remove any lines that excel guessed
choose mdy (or dmy) to match the data

Shams wrote:

Thank you very much for all of your inputs. The original data came from a
mainframe file and for some reason was still being referenced with .txt
features even though it was transferred into excel. I basically replicated
that scenario by first taking my raw data and saving it as comma delimited
and then opening it back again in excel..I reformated the Date column as date
and ran my Pivot..the Group By Date worked like a charm. I am not sure why
it happened but it seemed to have worked. Thanks, again.

"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