grouping dates in pivot table

I have an outstanding checklist which contains two accounts (account 2110
and 2189) I have created a pivot table using the date of the check on the
left, the account on top and the amounts as the data. Example

Account 2110 2189
Date
7/3/04 105 176
7/6/04 116 218
8/3/04 786 197
8/7/04 214 767

I am trying to group the dates so it will read total amount of outstanding
checks for the month. Example:

Account 2110 2189
Date
July '04 221 394
Aug 04 1000 964

When I highlight the word "Date" to group by month, I get a message that
says "Cannot Group this data"

What is the fastest way I can group by month?

Are your dates really dates? They're not just text typed into the cell to look
like dates. (You can check with a formula:

=isnumber(a2)
and copy down
If all of them returns TRUE, then they are dates.

If you have empty cells in your date range, then this would be a problem, too.

If you don't have gaps in your range, you could use just one formula:
=counta(a2:a999)=count(a2:a999)
(adjust the range to match)

If that returns True, then they are dates.



Charles Maronski wrote:
>
> I have an outstanding checklist which contains two accounts (account 2110
> and 2189) I have created a pivot table using the date of the check on the
> left, the account on top and the amounts as the data. Example
>
> Account 2110 2189
> Date
> 7/3/04 105 176
> 7/6/04 116 218
> 8/3/04 786 197
> 8/7/04 214 767
>
> I am trying to group the dates so it will read total amount of outstanding
> checks for the month. Example:
>
> Account 2110 2189
> Date
> July '04 221 394
> Aug 04 1000 964
>
> When I highlight the word "Date" to group by month, I get a message that
> says "Cannot Group this data"
>
> What is the fastest way I can group by month?

--

Dave Peterson

Dave,

Thank you very much. I had empty cells in the date range. I was highlighting
the entire columns which gave me the empty cells. When I highlighted just
the data I needed, I was able to group by the month. Thanks again for the
help.

"Dave Peterson" <ec35720@netscapeXSPAM.com> wrote in message
news:428F6AF3.9C7969A0@netscapeXSPAM.com...
> Are your dates really dates? They're not just text typed into the cell to
> look
> like dates. (You can check with a formula:
>
> =isnumber(a2)
> and copy down
> If all of them returns TRUE, then they are dates.
>
> If you have empty cells in your date range, then this would be a problem,
> too.
>
> If you don't have gaps in your range, you could use just one formula:
> =counta(a2:a999)=count(a2:a999)
> (adjust the range to match)
>
> If that returns True, then they are dates.
>
>
>
> Charles Maronski wrote:
>>
>> I have an outstanding checklist which contains two accounts (account 2110
>> and 2189) I have created a pivot table using the date of the check on the
>> left, the account on top and the amounts as the data. Example
>>
>> Account 2110 2189
>> Date
>> 7/3/04 105 176
>> 7/6/04 116 218
>> 8/3/04 786 197
>> 8/7/04 214 767
>>
>> I am trying to group the dates so it will read total amount of
>> outstanding
>> checks for the month. Example:
>>
>> Account 2110 2189
>> Date
>> July '04 221 394
>> Aug 04 1000 964
>>
>> When I highlight the word "Date" to group by month, I get a message that
>> says "Cannot Group this data"
>>
>> What is the fastest way I can group by month?
>
> --
>
> Dave Peterson