IF AND FORMULA

Fialko66 · 04/04/23

Can anyone help with this formula please as i have tried to get it to work unsuccessfully but might even be barking up the wrong tree altogether

=IF (NOT (AND (G2 = "COMPLETE",C2 < today()),"OVERDUE",""))

Basically i want the cell to flag as 'OVERDUE' if G2 does not have complete in it and C2's date is less than today

Thank you

Paul Newcome · 04/04/23

Try this:

=IF(AND(G2 <> "COMPLETE", C2< TODAY()), "OVERDUE")

Paul Newcome · 04/04/23

Try this:

=IF(AND(G2 <> "COMPLETE", C2< TODAY()), "OVERDUE")

Fialko66 · 04/04/23

Thanks Paul - Problem solved, i think i was over complicating it

Paul Newcome · 04/04/23

Happy to help. 👍️

Best Answer