please help me add 1, 2 or 3 years to a date in Excel (O365)

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

Hello and welcome to the forum.

Since 1 year is 12 months, I would use something like this:

=EDATE(F2,A1*12)

Where your date is in F2 and the number of years to add is in cell A1.

Thank you both but i get an #VALUE! error using both methods

The original DATE field is UK format 15/08/2018 if that helps

Thank you so much for your help, i can see my mistake now.

In the field that has the number of extra years to add it has the number followed by the word years;

1 Year
3 Years
3 Years

Any suggestions how i can just extract the first character?

=edate(f2,left(a1)*12)

Ali, wouldn't CHOOSE(A1,1,2,3) where A1 = 1, 2, or 3 be the same as simply using A1?