Formula for figuring end date

[bamacwby]

Good Morning,
I'm trying to figure out the formula if I have a drop down list of different warranty times and a known start date, how do I get a formula for the end date for the warranty that is selected form the dropdown list. Column G has the warranty drop down list. The second image shows the different warranties times. Thank you

 

[etaf]

can you add a column with just the year number or months , rather than all the text
and then you can use a lookup , taking the startdate and adding 1 year or 2 years from the new column

=warranty end date

=DATE(YEAR(B2),MONTH(B2)+INDEX($H$2:$H$5,MATCH(A2,$G$2:$G$5,0)),DAY(B2))

see example , which can then be adapted

Book2
	A	B	C	D	E	F	G	H
1	vendor	start date		end date				month
2	a	1/1/24		1/1/25			a	12
3	c	3/23/24		3/23/26			b	6
4	b	6/15/24		12/15/24			c	24
5	a	3/16/24		3/16/25			d	6
Sheet1

Cell Formulas
Range	Formula
D2:D5	D2	=DATE(YEAR(B2),MONTH(B2)+INDEX($H$2:$H$5,MATCH(A2,$G$2:$G$5,0)),DAY(B2))

 

[Joe4]

Here is a little shorter formula, based on efate's example:

=EDATE(B2,VLOOKUP(A2,$G$2:$H$5,2,0))