NESTED IF STATEMENT USING DATE
Thank you Mike. With a slight correction it worked.
SJ
"Mike H" wrote in message
...
Try
=IF(TEXT(D2,"yyyy")="2007",2007,IF(TEXT(A13,"yyyy" )="2006",2006,2005 & "
Before"))
Mike
"SSJ" wrote:
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
|