Hi All
I have a spreadsheet with dates in it that i would like to add either 1, 2 or 3 years to. There is a cell that lists if the customer bought a 1, 2 or 3 year licence so i need the formula to check that cell and then add the number of years.
I started with this =DATE(YEAR(F2)+1,MONTH(F2),DAY(F2)) but i can't make a formula that checks a cell and then adds that number of years.
Any help or advice would be most welcome. Thank you
I have a spreadsheet with dates in it that i would like to add either 1, 2 or 3 years to. There is a cell that lists if the customer bought a 1, 2 or 3 year licence so i need the formula to check that cell and then add the number of years.
I started with this =DATE(YEAR(F2)+1,MONTH(F2),DAY(F2)) but i can't make a formula that checks a cell and then adds that number of years.
Any help or advice would be most welcome. Thank you