SOLVED

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

%3CLINGO-SUB%20id%3D%22lingo-sub-2375940%22%20slang%3D%22en-US%22%3ETrying%20to%20create%20an%20IF%20Statement%20for%20a%20date%20out%20from%20current%20date%20when%20a%20certain%20letter%20is%20chosen%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2375940%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20create%20an%20IF%20statement%20where%20if%20a%20certain%20letter%20is%20chosen%20it%20would%20create%20a%20%22Date%20to%20Review%22%20in%20the%20future.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIF%20a%20Delinquency%20Letter%20is%20chosen%20we%20review%20it%2030%20days%20in%20the%20future%20from%20%22Date%20Sent%22%20or%20if%20a%20Revocation%20Letter%20is%20chosen%20we%20review%20it%2010%20days%20in%20the%20future%20from%20%22Date%20Sent%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF%20(E3%3DDelinquency%20Letter)%2C...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22HighFiveEm_2-1621609299775.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F282668i9EB23C6E38D761D3%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22HighFiveEm_2-1621609299775.png%22%20alt%3D%22HighFiveEm_2-1621609299775.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2375940%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2375963%22%20slang%3D%22en-US%22%3ERe%3A%20Trying%20to%20create%20an%20IF%20Statement%20for%20a%20date%20out%20from%20current%20date%20when%20a%20certain%20letter%20is%20chose%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2375963%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1060092%22%20target%3D%22_blank%22%3E%40HighFiveEm%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20B3%3A%3C%2FP%3E%0A%3CP%3E%3DIF(E3%3D%22Delinquency%20Letter%22%2CA3%2B30%2CIF(3%3D%22Revocation%20Letter%22%2CA3%2B10%2C%22%22))%3C%2FP%3E%0A%3CP%3EIf%20necessary%2C%20format%20B3%20as%20a%20date.%3C%2FP%3E%0A%3CP%3EFill%20down.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional 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 (Occasional 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