If d2 is a properly formatted date then this works.

=IF(YEAR(D2)2005,YEAR(D2),"2005 & before")

--
Don Guillett
SalesAid Software

"SSJ" wrote in message ...
Hello!

Can some review the following IF statement. The error is stating that there are too many arguments.

=IF((TEXT((D2),"yyyy")="2007"),"2007",if(TEXT(d2), "yyyy")="2006","2006","2005 & Before")



If the year of the date is 2007, state "2007", If the year of the date is 2006, state "2006", otherwise state "2005 & Before"



Thanks in advance



SJ