IF and AND formula for date field
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)))
|