That date would be in A2 in my example.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"xenophon" wrote in message
...
Could you please explain me in details how, with exemple for the date of
25/1/2005 ?

Thanks,

"Bob Phillips" wrote:

Why not just add another column and calculate the quarter,

=YEAR(A2)&"Q"&INT((MONTH(A2)-1)/3)+1

and add that to the pivot

--

HTH

RP
(remove nothere from the email address if mailing direct)


"xenophon" wrote in message
...
I want to put a criteria like "Between 1/1/2005 And 31/3/2005" in a
Pivot
Table without selcting the different dates one by one . I have a data
with
Invoice dates and I want to view it by Quarter and not by single date
(ex:
25/1/2005)