May 21 2021 08:09 AM
I am trying to create an IF statement where if a certain letter is chosen it would create a "Date to Review" in the future.
IF a Delinquency Letter is chosen we review it 30 days in the future from "Date Sent" or if a Revocation Letter is chosen we review it 10 days in the future from "Date Sent".
=IF (E3=Delinquency Letter),...
May 21 2021 08:19 AM
SolutionIn B3:
=IF(E3="Delinquency Letter",A3+30,IF(3="Revocation Letter",A3+10,""))
If necessary, format B3 as a date.
Fill down.
May 21 2021 08:45 AM
May 21 2021 08:19 AM
SolutionIn B3:
=IF(E3="Delinquency Letter",A3+30,IF(3="Revocation Letter",A3+10,""))
If necessary, format B3 as a date.
Fill down.