Nov 03 2021 09:35 AM
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.
Nov 03 2021 09:45 AM
SolutionNov 03 2021 09:52 AM
Nov 03 2021 09:45 AM
Solution