Formula for Milestone Health

Rob_NYC

I'm trying to figure out a formula for "Site Health". Each site has 9 milestones that will have a "Milestone Health" column. Each milestone must be completed a certain number of days before the project end date (October 31-22). I don't know how to create a formula to make the milestone health Green, Yellow and Red. At the end there is a column "Site Health" which I think is the average of all milestones health .

I appreciate very much if someone can help me!

Thank you very much!😉

Rob

Paul Newcome

What are your requirements for RYG?