SOLVED

Trying to create an IF Statement for a date out from current date when a certain letter is chosen

Copper Contributor

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),...

 

HighFiveEm_2-1621609299775.png

 

 

 

2 Replies
best response confirmed by HighFiveEm (Copper Contributor)
Solution

@HighFiveEm 

In B3:

=IF(E3="Delinquency Letter",A3+30,IF(3="Revocation Letter",A3+10,""))

If necessary, format B3 as a date.

Fill down.

Thank you Hans, that was spot on. Greatly appreciated
1 best response

Accepted Solutions
best response confirmed by HighFiveEm (Copper Contributor)
Solution

@HighFiveEm 

In B3:

=IF(E3="Delinquency Letter",A3+30,IF(3="Revocation Letter",A3+10,""))

If necessary, format B3 as a date.

Fill down.

View solution in original post