'RIGHT(TEXT(D21,"dd mmm yyyy"),4)

if your date is in d21 this will return the text number 2006, say...

you could then apply an IF statement to this


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=528497