I have an if formula for certifications. I have 3 cells, cell A is versions which include "elements", "elements+" and "advanced". Cell B is the date they received that certification and cell C is the expiration date. I would like cell C to be either one or two years after cell B depending on what version. Elements and Elements+ is 2 years, Advanced is 1. If it's blank, just leave it blank. Does this make sense and would you be able to help me?
Solved by C. C. in 15 mins