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)))