I have a nesting formula I am trying to restrict the out put by todays date -7

Copper Contributor

=IF(E2=1, "letter 2", IF(E2=2,"letter 3", IF(E2=3, "call", "nothing issued")))

The above gives me the correct output necessary for determining which letter I next need to issue, however, I would like to be able to limit the output by cell E3 which contains the date; therefore, I am looking to only produce the above IF outcome if the date in E3 is 7 days prior to today.

 

Your assistance is greatly appreciated.

1 Reply

One more IF on the top

=IF(E3=TODAY()-7,IF(E2=1, "letter 2", IF(E2=2,"letter 3", IF(E2=3, "call", "nothing issued"))),"")