Using IF(AND to mark yes if 3 different columns are true (one ISBLANK and one (NOT(ISBLANK))

@LS

Hoping that someone can help me figure out what I am doing wrong in this formula or another way to do this. I want the "D84 OOW w/No complete date" to say "YES" if the "D84 Completed date" is BLANK, AND the "D56 completed date" is NOT BLANK, AND the "D84 window end" is < today [note: D84 window end will be populated when the D56 complete date is entered]

Thanks

Paul Newcome

It looks like you have a misplaced closing parenthesis. Try moving one from the end to after the NOT/ISBLANK piece to close out the AND statement.