Training Formula Question

[francoiscj1]

=IF(CountA(F1:H1)<2, "", If(Max(F1:H1)<=G1, "Compliant","Noncompliant"))



What I would like to do:

1) If G1 has an expired date and no retraining date in H1, cell I1 will be "Noncompliant".

2) If H1 has a retraining date that is after the expired date in G1, cell I1 will be "Noncompliant".

3) If H1 has a retraining date that is before or on the expired date in G1, cell I1 will be "Compliant".

I hope this makes sense. Thank you for the help.

 

[Sufiyan97]

Try

=IF(OR(AND(ISNUMBER(G1),H1=""),H1>G1),"Noncompliant","Compliant")