I am certain this should be an easy fix however I am having a terrible time trying to figure out why my formula is not working as it should. The below formula worksif conditions are met, but not if they have not been met. For example each cellreferenced has a date for its value. I want my...