Set RAG based on % Complete & Deadline Date Proximity
I am trying to get my formula to set a RAG status based on the % complete and deadline date proximity. My formula is:
However, the last entry with a deadline date of 12/11 show be showing a "Yellow" RAG but, it still shows "Red". What have I missed?