I am really struggling to get the correct formula for below situation:
Cell A2 is a "due date"
Cell B2 is a "completion date"
Cell C2 is a "current progress"
In cell C2 I am trying without success to insert an IF formula so that:
1 - if A2 <= Today() then value in C2="Open - Late"
2 - if A2 > Today() then value in C2="Open - On time"
the 2 above conditions, considering B2 is empty
when B2 is filled in, what i am looking to include in the formula is that
3 - if A2 >= B2 then value in C2="Completed - On time"
4 - if A2 < B2 then value in C2="Completed - Late"