I have a spreadsheet that list a planned completion date and then has an
actual completion date. I have a formula that places a Y or N depending if
production met the contractual due out date or not. What I want to do is
calculate my % effective based on the "Yes" and "No" criteria. Is there a
way?