Is there any way to have these 2 statement combine into one statement or put into one cell?
=IF(AND(G4<>"",G4<=TODAY(),I4>0),"Pass due by "&(TODAY()-G4)&" Days","")
=IF(AND(G4<>"",G4>=TODAY(),I4<>0),"Due In "&(TODAY()-G4)&" Days","")
or is there a easy way to do this ?