Out of Practice, Need 2 Variable Flag (At Risk) Help

KristiTRUSD

I haven't been a good girl practicing my formulas. Everything I've tried is coming up Uparseable.

What I'd like to do: Red Flag when "Expected Completion Date" is within 5, days, or in the past, and "Current Status" does NOT equal "Complete".

I'm feeling pretty silly that I've spent so much time trying to get this to work. I'd love any help offered on a working formula

Paul Newcome

Try something like this:

=IF(AND([Current Status]@row <> "Complete", [Expected Completion Date]@row <= TODAY(5)), 1)