Forum Discussion
Solved
Date Comparison
Hello Everyone, I am trying to create a logic by comparing the dates. I want to be show the status as "Triggered On Time", "Triggered Late", "Past Due", "To be Triggered" and the logic I am trying ...
rituraj851 Try following formula. See the attachment.
=IF(AND(C2="",B2<E2),"Past Due",IF(AND(C2="",B2>=E2),"To be Triggered",IF(AND(C2<>"",C2<=B2),"Triggered On Time",IF(AND(C2<>"",C2>B2),"Triggered Late","Sothething Else"))))
rituraj851 Try following formula. See the attachment.
=IF(AND(C2="",B2<E2),"Past Due",IF(AND(C2="",B2>=E2),"To be Triggered",IF(AND(C2<>"",C2<=B2),"Triggered On Time",IF(AND(C2<>"",C2>B2),"Triggered Late","Sothething Else"))))
Harun24HR - Thanks You very much for your support. It is working fine. )