Compare Dates - slight issue with current formula

[ldurham]

Trying to get formula in column U to work and be consistent with column S
EXAMPLE of formula not working properly is row 8

[x65140]

Wondering about your value in C (and other blank columns). Your first check for C was low values....what if you also checked for spaces?
i.e. =IF(OR(C8<>"",C8<>" "),IF(AND(F8="",I8=""),"T3 trained not certified",IF(MAX(F8,I8)>TODAY(),"Current","Certified after T3 - Expired")),"Current - need T3 date")

[José Augusto]

Hi
Try this formula in U3 and copy down

Please Login or Register  to view this content.

[ldurham]

that worked for row 8 the one not working properly
but it doesn't work for the rest of the rows.. They all say "Certified after T3 - Expired" YIKES

[CAntosh]

Your current formula is set to return "Current - need T3 date" every time the C value is blank. What process would you like to be taken instead when C3 is blank? Should it follow the same progression as the non-blank entries? If so, nothing will ever be "Current - need T3 date". I think your nested IFs just need a little tweaking, but some clarification on each possible path would help.

[x65140]

not sure who you were responding to ldurham.....here is what i had....

[ldurham]

X65140 , just tried this again and it seems to work great ! Thanks, LaDonna http://www.excelforum.com/images/smilies/smile.gif