SOLVED

IF THEN Excel Formula assistance request

%3CLINGO-SUB%20id%3D%22lingo-sub-2922124%22%20slang%3D%22en-US%22%3EIF%20THEN%20Excel%20Formula%20assistance%20request%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2922124%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20starting%20with%202%20cells%20with%20data.%26nbsp%3B%20A1%20has%20a%20date%20ex.%2011%2F03%2F2020.%26nbsp%3B%20C1%20is%20blank%20with%20an%20option%20to%20pick%20YES%20or%20NO.%26nbsp%3B%20I%20need%20a%20formula%20with%20a%20condition%20that%20IF%20enter%20YES%20in%20into%20C1%2C%20then%20in%20B1%2C%20it%20will%20show%20the%20date%20from%20A1%20plus%201%20year.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20IF%20YES%20in%20C1%20THEN%20B1%20would%20auto%20populate%20with%2011%2F03%2F2021.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20possible%3F%26nbsp%3B%20If%20so%2C%20please%20provide%20a%20workable%20formula.%26nbsp%3B%20I%20would%20be%20eternally%20grateful.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2922124%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2922193%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20THEN%20Excel%20Formula%20assistance%20request%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2922193%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1205728%22%20target%3D%22_blank%22%3E%40Ihbe76%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20B1%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DIF(OR(A1%3D%22%22%2CC1%26lt%3B%26gt%3B%22YES%22)%2C%22%22%2CEDATE(A1%2C12))%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2922258%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20THEN%20Excel%20Formula%20assistance%20request%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2922258%22%20slang%3D%22en-US%22%3EThank%20you.%20You%20saved%20me%20from%20hours%20of%20research.%3C%2FLINGO-BODY%3E
New Contributor

I am starting with 2 cells with data.  A1 has a date ex. 11/03/2020.  C1 is blank with an option to pick YES or NO.  I need a formula with a condition that IF enter YES in into C1, then in B1, it will show the date from A1 plus 1 year. 

 

So IF YES in C1 THEN B1 would auto populate with 11/03/2021. 

 

Is this possible?  If so, please provide a workable formula.  I would be eternally grateful.

2 Replies
best response confirmed by Ihbe76 (New Contributor)
Solution

@Ihbe76 

In B1:

 

=IF(OR(A1="",C1<>"YES"),"",EDATE(A1,12))

Thank you. You saved me from hours of research.