Good thinking Mr Sjoblom!

nikko,

try this attempt

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

--
__________________________________
HTH

Bob

"Peo Sjoblom" wrote in message
...
I suspect the OP has leading spaces that way you would get value errors

--


Regards,


Peo Sjoblom

"Bob Phillips" wrote in message
...
It works for me even if the cells are text.

Can you post a sample workbook somewhere on one of the web share sites.

--
__________________________________
HTH

Bob

"nikko" wrote in message
...
bob, how do i ensure the dates are real dates?
i have selected the columns, right-click and select format cells and
ensure
that the date category is selected but i still get the #value error..

--
nikko