Feb 15 2018
03:17 AM
- last edited on
Jul 25 2018
11:04 AM
by
TechCommunityAP
Feb 15 2018
03:17 AM
- last edited on
Jul 25 2018
11:04 AM
by
TechCommunityAP
=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.
Feb 15 2018 03:27 AM
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"))),"")