Multi IF function with Dynamic Date

[tward]

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

[camalone319]

So to clarify you want it to display:

SEND when X4 is > 90 and TODAY is > Q4
DON'T SEND when X4 < no matter what today and Q4 are

[tward]

SEND when X4 is > 90 and TODAY is > Q4
DON'T SEND when X4 < 90 no matter what today and Q4 are

Yes.

[camalone319]

I think this is formula your looking for...

=IF(X4<90,"DON'T SEND",IF(B1>P4,"SEND","DON'T SEND"))

this basically says 1st check if CSA RENW - CC Days is < 90, if so Don't Send. If it's not, check to see if Today is > CSA RENW Date. If it is, SEND, if not don't send.

Note: You should use B1 to compare to P4, not B2 to Q4.