Could somebody help with a question I have. I'm stuck with an excel formula. I need an indicator to tell me when something is on target or out of target.

I've attached a screen shot of an example where I have a deadline, the date it was completed and what it should read along with how far I got writing a formula. If somebody could help me I would be grateful.

It should flow like this; if deadline(A2) is before today and date completed (B2) is blank OR/AND if date completed (B2) is more than the deadline (A2) then it is out of target, if not it is in target. Can't get it right so help would be appreciated.

=IF(AND(ISBLANK(B2),A2>TODAY(),OR(B2>A2)),"On Target","Out of Target")

• Formula used in cell C2

=CHOOSE((((A2>TODAY()) (B2="")) (B2>A2)) 1,"On Target","Out Of Target")

Or,

• Formula used in cell D2

=IF(OR(OR(A2>TODAY(),B2=""),B2>A2),"Out Of Target","On Target")