I am trying to write an IF(AND formula using dates where all 3 dates must meet the criteria <=TODAY() to return an "Y" value.
The other option is to write an IF formula where if any of the dates are blank, it returns a "N" value. If all of the cells have dates, it returns
a "Y" value. I could use some help. I have tried multiple versions and cannot seem to get the right syntax. A sample file is attached. Thanks in advance.
Bookmarks