=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