At Risk formula help

Farha

Hello,

I need help with creating a 'At Risk flag' when End Date is reached and Status is not complete. I have tried multiple combinations, can someone please review and help me correct this formula

I am entering on Row4, End Date and Status are columns and Complete is a drop down under the status column.

=IF(AND[End Date]4 < TODAY(), NOT(Status4 = "Complete")), 1, 0)

Thank you!

Mike Wilday

Try this one. Does this work? 

=IF(AND[End Date]4 < TODAY(), Status4 <> "Complete"), 1, 0)