What I am trying to accomplish:
I want to combine the two formulas of cell Y4 and Z4. So that when cell Y4 reads "DON'T SEND" then it consistently checks the formula that is in cell Z4 with the TODAY() formula. Once Z4 is true then it overrides "DON'T SEND" with "SEND"
However if Y4 already reads "SEND" not to check the second formula.
Attached is my file.
Thanks in advance.Demo.xlsx
Bookmarks