Hello,
I have a date range:
Date Range Start & Date Range End, and I want to flag it if the "Actual Completion Date" is before the Date Range Start OR if the "Actual Completion Date" is after the Date Range End.
Can anyone help?
I've tried:
=IF([Actual Completion Date]@row > [Date Range Start]@row, OR([Actual Completion Date]@row > [Date Range End]), 1,0))
=IF(AND([Actual Completion Date]@row > [Date Range Start]@row, OR([Actual Completion Date]@row > [Date Range End]), 1,0))
