I'm confused.
Post your actual layout or send a workbook to my personal address below with
exactly what you want.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"nikko" wrote in message
...
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