I can't seem to get this quite right.
A1 is 1/1/2014
A2 calculates the days between today's date and A1
A3 is IF(A2>120,"EXPIRED","ACTIVE")
I want A3 to only perform the IF statement when A1 has a date and not when it's blank. I know the ISBLANK formula, but can't seem to get it nested correctly with my IF statement.
Thanks in advance!
Bookmarks