Sure was me, the whole column was formatted as text.
Thank you.

One more adjustment if its possible, for 2009 it returns Q2, Q3, Q4 instead
of 2009 Q2, 2009 Q3...is there a way to adjust the last leg to return the
year and the quarter instead of just the quarter?

Please advise.
Thank you.
Monika

"Fred Smith" wrote:

Did you put an equal sign in front of the formula? Is the cell formatted for
text? Either of these would cause the problem you described.

It works for me when I test it, so the problem has to be operator error.

Regards,
Fred

"murkaboris" wrote in message
...
Hello:

didn't work, it didn't give me any error just showed the formula as typed
in...
Please advise.
Thank you.
Monika

"jasontferrell" wrote:

Try this:
=IF(B2<DATEVALUE("01/02/2009"),YEAR(B2),IF(B2DATEVALUE
("01/01/2010"),YEAR(B2),"Q"&(INT(MONTH(B2)/4)+1)))