francoiscj1
New Member
- Joined
- Aug 21, 2017
- Messages
- 33
- Office Version
- 365
- Platform
- Windows
=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.
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.