Project RAG Formula

[John Berman]

Hi

I have a project with start and finish dates I want to add a RAG Column which calculates like to

Red if Finish Date is Greater than 31 Dec 2015
Amber if Finish date is Greater than 31 Oct 2015 but less than 31 Dec 2015

Green if Finish date is less than 31 Oct 2015

Regards

John B

[Ismet Kocaman]

Pls see the picture here: https://tinyurl.com/quickRAG
And also see Dale A. Howard (MVP)’s solution here for an alternative RAG scenario:
https://answers.microsoft.com/en-us/office/forum/office_2013_release-project/rag-status-for-date-ranges/76f7c637-a7fd-401e-b543-2d713a9c949c

[Author]

Posts