Add or subtract durations in years, months, days format

[Tlsoi]

Hello everyone,

I am trying to add or subtract durations in years, months, days format; but i could not figure it out how to do it.

For example, Column A, B and C refers to years, months and days respectively.

A1 = 4 (years), B1 = 7 (months), C1 = 19 (days)
A2 = 1 (years), B2 = 11 (months), C2 = 20 (days)

I want to add or subtract these two rows and show it in row 3.
If i add them up, the result will be 5 years, 18 months, 39 days. However, i want it to shift the days bigger than 30 and the months bigger than 12 to aside and automatically calculate the result as 6 years, 7 months and 9 days.

I really apprecatiate your help.

 

[jasonb75]

Something like this perhaps?

Book1
	A	B	C
1	Years	Months	Days
2	4	7	19
3	1	11	20
4
5	6	7	9
Sheet1

Cell Formulas
Range	Formula
A5	A5	=SUM(A2:A3,INT(SUM(B2:B3,INT(SUM(C2:C3)/30))/12))
B5	B5	=MOD(SUM(B2:B3,INT(SUM(C2:C3)/30)),12)
C5	C5	=MOD(SUM(C2:C3),30)
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[jtakw]

Hi,

Try:

Book3.xlsx
	A	B	C
1	4	7	19
2	1	11	20
3	6	7	9
Sheet854

Cell Formulas
Range	Formula
A3	A3	=A1+A2+INT((B1+B2)/12)
B3	B3	=MOD(B1+B2,12)+INT((C1+C2)/30)
C3	C3	=MOD(C1+C2,30)

 

[Tlsoi]

Dear jasonb75 and jtakw, thank you so much. I am grateful for your help.

 

[jtakw]

You're welcome, thanks for the feedback.