If >12...

[Guest]

Hello!
In next situation:
35 years=Sum(A2:A3)
15 months=Sum(B2:B3)

yy mm
30 6
5 9
35 15

I would like:
Where is 15, calc 3 (15 months - 12/year)
and
where is 35, calc 36 (+ 1 year=12 months)

Thanks in advance.
an

 

[Roger Govier]

Hi

If I understand your requirement correctly, in cell A4

=SUM(A2:A3)+INT(SUM(B2:B3)/12)
in Cell B4
=MOD(SUM(B2:B3),12)


Regards

Roger Govier

 

[Bernie Deitrick]

an,

In A4:
=SUM(A2:A3)+INT(SUM(B2:B3)/12)

In B4
=MOD(SUM(B2:B3),12)

HTH,
Bernie
MS Excel MVP

 

[Guest]

Thanks for your solution.
an

Hi

If I understand your requirement correctly, in cell A4

=SUM(A2:A3)+INT(SUM(B2:B3)/12)
in Cell B4
=MOD(SUM(B2:B3),12)


Regards

Roger Govier

 

[Guest]

Thanks for your solution, too.
an

an,

In A4:
=SUM(A2:A3)+INT(SUM(B2:B3)/12)

In B4
=MOD(SUM(B2:B3),12)

HTH,
Bernie
MS Excel MVP