Formula to add years and months

[mdnsh]

Hello All,

What could be the formula for total years ( 8 Years, 3 Months) in the below case?

Thanks in advance.

 

[Peter_SSs]

Something like this?

24 10 09.xlsm
	A	B	C
1
2	4 Years, 1.5 Months	4 Years, 1.5 Months	8 Years, 3 Months
3	6 Years, 1.5 Months	4 Years, 7 Months	10 Years, 8.5 Months
4	4 Years, 1.5 Months	8 Years, 11.5 Months	13 Years, 1 Months
Years Months

Cell Formulas
Range	Formula
C2:C4	C2	=LET(a,TEXTSPLIT(A2&B2,{"Years, "," Months"}),m,SUM(--INDEX(a,{2,4})),SUM(--INDEX(a,{1,3}),INT(m/12))&" Years, "&MOD(m,12)&" Months")

 

[mdnsh]

Something like this?

24 10 09.xlsm
	A	B	C
1
2	4 Years, 1.5 Months	4 Years, 1.5 Months	8 Years, 3 Months
3	6 Years, 1.5 Months	4 Years, 7 Months	10 Years, 8.5 Months
4	4 Years, 1.5 Months	8 Years, 11.5 Months	13 Years, 1 Months
Years Months

Cell Formulas
Range	Formula
C2:C4	C2	=LET(a,TEXTSPLIT(A2&B2,{"Years, "," Months"}),m,SUM(--INDEX(a,{2,4})),SUM(--INDEX(a,{1,3}),INT(m/12))&" Years, "&MOD(m,12)&" Months")

Hi Peter,

Thank you for the response.
Tried the same and getting an error. Am i missing something here? Thanks.

 

[Peter_SSs]

Tried the same and getting an error. Am i missing something here?

That would indicate that either ..

• You do not have Microsoft 365 as your profile indicates or
• You do have 365 but have not applied available updates to it.