Hi, need help on below:-

i'm trying to have a formula that show if the Close date has been changed
for data as of May 2008 and June 2008 and if this change is a Push-out,
Pull-In or No change.
I will also like the formula to show if the close date as of June 2008 is
within the quarter or outside of the quarter.

Below is the formula i've tried to use but return no value.
=IF(AND(F2F3, F339538, F3<39630), "In-In", "In-Out"), IF(AND(F2<F3,
F339538, F3<39630), "Out-In", "Out-Out"), IF(AND(F2=F3, F339538, F3<39630),
"NC-In", "NC-Out")

F2 - close date as of May 2008
F3 - close date as of June 2008
If close date is between 1 April to 30 Jun 2008, then it's within the quarter
If close date is not within this period, then it should show as Outside of
quarter

Please help . thanks
--
nikko