francoiscj1
New Member
- Joined
- Aug 21, 2017
- Messages
- 33
- Office Version
- 365
- Platform
- Windows
Here is my information:
Column E: Frequency
Column F: Training Date
Column G: Expiration Date
Column H: Retraining Date
Column I: Status
Here is my formula:
=If(E13="One Time", "Compliant", If(or(IsBlank(F13), IsBlank(G13), IsBlank(H13)),"",If(H13<=G13,"Compliant","Non-Compliant")
I would like to modify the above formula to include the following:
1) If the expiration date is not due and if there is no retraining date then the status should be "Not Due"
2) if the expiration date has passed and if there is no retraining date then the status should be "Due"
Thank you for the help.
Column E: Frequency
Column F: Training Date
Column G: Expiration Date
Column H: Retraining Date
Column I: Status
Here is my formula:
=If(E13="One Time", "Compliant", If(or(IsBlank(F13), IsBlank(G13), IsBlank(H13)),"",If(H13<=G13,"Compliant","Non-Compliant")
I would like to modify the above formula to include the following:
1) If the expiration date is not due and if there is no retraining date then the status should be "Not Due"
2) if the expiration date has passed and if there is no retraining date then the status should be "Due"
Thank you for the help.