SOLVED

IF THEN Excel Formula assistance request

Copper 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 (Copper Contributor)
Solution

@Ihbe76 

In B1:

 

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

Thank you. You saved me from hours of research.
1 best response

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

@Ihbe76 

In B1:

 

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

View solution in original post