Formula for Date

[AndrewTrevayne]

Hi all,
Can you help me with a formula on date?
Basically, I want to add Years on the date based on a criteria.

Logic is:
If date in columnA is paired with X in ColumnB add 1 year to ColumnC
If date in columnA is paired with Z in ColumnB add 2 years to ColumnC
If date in columnA is paired with Y in ColumnB add 3 years to ColumnC

Thanks in advance.

 

[Dave Patton]

2 alternatives

T202208a.xlsm
	A	B	C	D	E	F
1
2	10-Aug-22	X	10-Aug-23	10-Aug-23	X	12
3					Y	36
4					Z	24
5
3a

Cell Formulas
Range	Formula
C2	C2	=EDATE(A2,LOOKUP(B2,E2:F4))
D2	D2	=EDATE(A2,IF(B2="X",12,IF(B2="Y",36,IF(B2="Z",24,0))))

 

[Phuoc]

Book1
	A	B	C
1	10/8/2022	X	10/8/2023
2	10/8/2022	Y	10/8/2024
3	10/8/2022	Z	10/8/2025
Sheet1

Cell Formulas
Range	Formula
C1:C3	C1	=EDATE(A1,SEARCH(B1,"XYZ")*12)

 

[kevin9999]

Book2
	A	B	C
1	10/08/2022	X	10/08/2023
2	10/08/2022	Y	10/08/2024
3	10/08/2022	Z
Sheet3

Cell Formulas
Range	Formula
C1	C1	=EDATE(A1,LOOKUP(B1,{"X","Y","Z"},{12,24,36}))
C2	C2	=IFS(B2="X",EDATE(A2,12),B2="Y",EDATE(A2,24),B2="Z",EDATE(A2,36))

 

[AndrewTrevayne]

Thank you everyone! Much appreciated.

 

[kevin9999]

Thank you everyone! Much appreciated.

Glad we could help, and thanks for the feedback - although I personally thought @Phuoc 's solution in post #3 was the best...

 

[Dave Patton]

thought @Phuoc 's solution in post #3 was the best... I agree

@Phuoc 's solution is logical but the specifications did say


Logic is:
If date in columnA is paired with X in ColumnB add 1 year to ColumnC
If date in columnA is paired with Z in ColumnB add 2 years to ColumnC
If date in columnA is paired with Y in ColumnB add 3 years to ColumnC