Hello Forum,
I was hoping someone could help me out. I'm looking for a formula that can look at three fields in date format. From there it needs to be able to identify:
1. All 3 parameters have been completed (date filled in the box)
or
2. At least 1 of the parameters (dates) is within the past year
Oh, and once the formula has identified the answer, a simple yes/no to populate in the box would be great.
I've attached an image with an example... Forum Question.JPG
Thanks everyone!
Bookmarks