Forum Discussion
Solved
help with an excel formula - pulling my hair out!
Can anyone please help create a formula for me, I have two date columns, start date and due date. I also have a % completion column. I need to RAG rate the status based up on todays date, proximity ...
It gives G
and attached
Thanks so much for the reply, its nearly right, but I'm getting an A response where the work is 50% complete or more and there is less than 2 weeks to the due date, I'm also getting an A when the work is 100% complete but the due date has passed, I'd expect G for both of these, can you have another look please. Thanks so much.
It gives G
and attached
fantastic, my mistake! thanks again.