Bob, i copied the formula you provided earlier and the result is #value!
except for one item ... it shows push out of quarter but when i take a
further look; the old n new values are within the quarter (same month) ..

Old Value New Value Formula
28/11/2008 08/09/2008 #VALUE!
30/09/2008 28/11/2008 #VALUE!
28/11/2008 18/08/2008 #VALUE!
22/08/2008 29/09/2008 #VALUE!
22/12/2008 18/08/2008 #VALUE!
30/07/2008 18/08/2008 #VALUE!
24/11/2008 30/09/2008 #VALUE!
30/09/2008 24/11/2008 #VALUE!
29/08/2008 30/09/2008 #VALUE!
18/07/2008 18/08/2008 #VALUE!
28/11/2008 18/08/2008 #VALUE!
27/09/2008 19/08/2008 #VALUE!
29/08/2008 19/09/2008 #VALUE!
17/10/2008 26/08/2008 #VALUE!
30/05/2008 26/08/2008 #VALUE!
29/08/2008 26/09/2008 #VALUE!
26/08/2008 01/07/2008 #VALUE!
29/08/2008 11/09/2008 #VALUE!
11/08/2008 29/08/2008 #VALUE!
18/08/2008 24/08/2008 #VALUE!
11/07/2008 18/08/2008 #VALUE!
24/09/2008 26/09/2008 #VALUE!
11/07/2008 26/08/2008 #VALUE!
28/08/2008 24/09/2008 #VALUE!
27/08/2008 24/09/2008 #VALUE!
29/08/2008 19/09/2008 #VALUE!
18/08/2008 05/08/2008 #VALUE!
22/09/2008 30/09/2008 #VALUE!
01/09/2008 04/09/2008 Push out of quarter
30/09/2008 19/09/2008 #VALUE!
30/09/2008 04/09/2008 #VALUE!


--
nikko


"Bob Phillips" wrote:

=IF(YEAR(A2)*10+INT((MONTH(A2)+2)/3)=YEAR(B2)*10+INT((MONTH(B2)+2)/3),"Within
the quarter",
IF(YEAR(A2)*10+INT((MONTH(A2)+2)/3)YEAR(B2)*10+INT((MONTH(B2)+2)/3),"Pull
in","Push out of quarter"))

--
__________________________________
HTH

Bob

"nikko" wrote in message
...
Hi

I have a tracking spreadsheet that contains all the deals with the close
date change..

there's a close date old value in column A and a close date new value in
column B

is there a formula where i can use to determine if the change of date is
within the quarter; pull in or push out of quarter ?

Column A Column B Formula
28-Nov-2008 12-Sep-2008 Pull in
28-Nov-2008 20-Oct-2008 within the quarter
28-Nov-2008 10-Jan-2009 Push out of quarter

Any help is appreciated, Thanks!
--
nikko