SUM Days (to 30), Months (to 12) and Years
 

Hello!

I have:

YY MM DD
2 9 20
4 3 15

I would like your help for the next result after sum periods:

YY MM DD
7 1 5

Thanks in advance.
an

SUM Days (to 30), Months (to 12) and Years
 

Hi Just Extend the logic posted to your previous question on years and months.

=SUM(A2:A3)+INT(SUM(B2:B3)/12)
in Cell B4
=MOD(SUM(B2:B3),12)+INT(SUM(C2:C3)/30)
in cell C4
=MOD(SUM(C2:C3),30)

Note
This will not be accurate due to variation in month lengths.

Regards

Roger Govier


an wrote:
Hello!

I have:

YY MM DD
2 9 20
4 3 15

I would like your help for the next result after sum periods:

YY MM DD
7 1 5

Thanks in advance.
an

SUM Days (to 30), Months (to 12) and Years
 

=YEAR(DATE(A1+A2,B1+B2,C1+C2))-1900
=MONTH(DATE(A1+A2,B1+B2,C1+C2))
=DAY(DATE(A1+A2,B1+B2,C1+C2))

But you get 4, not 5 for the day.

--
Kind regards,

Niek Otten

"an" wrote in message
...
Hello!

I have:

YY MM DD
2 9 20
4 3 15

I would like your help for the next result after sum periods:

YY MM DD
7 1 5

Thanks in advance.
an

SUM Days (to 30), Months (to 12) and Years
 

In this case. If your data were
2 9 20
4 5 15

you would get 7 for the day

--
Kind regards,

Niek Otten

"Niek Otten" wrote in message
...
=YEAR(DATE(A1+A2,B1+B2,C1+C2))-1900
=MONTH(DATE(A1+A2,B1+B2,C1+C2))
=DAY(DATE(A1+A2,B1+B2,C1+C2))

But you get 4, not 5 for the day.

--
Kind regards,

Niek Otten

"an" wrote in message
...
Hello!

I have:

YY MM DD
2 9 20
4 3 15

I would like your help for the next result after sum periods:

YY MM DD
7 1 5

Thanks in advance.
an

SUM Days (to 30), Months (to 12) and Years
 

Exactly, RG

Many thanks, more one time.
an

"Roger Govier" wrote:

Hi Just Extend the logic posted to your previous question on years and months.

=SUM(A2:A3)+INT(SUM(B2:B3)/12)
in Cell B4
=MOD(SUM(B2:B3),12)+INT(SUM(C2:C3)/30)
in cell C4
=MOD(SUM(C2:C3),30)

Note
This will not be accurate due to variation in month lengths.

Regards

Roger Govier


an wrote:
Hello!

I have:

YY MM DD
2 9 20
4 3 15

I would like your help for the next result after sum periods:

YY MM DD
7 1 5

Thanks in advance.
an

SUM Days (to 30), Months (to 12) and Years
 

Thanks, too.
an

"Niek Otten" wrote:

In this case. If your data were
2 9 20
4 5 15

you would get 7 for the day

--
Kind regards,

Niek Otten

"Niek Otten" wrote in message
...
=YEAR(DATE(A1+A2,B1+B2,C1+C2))-1900
=MONTH(DATE(A1+A2,B1+B2,C1+C2))
=DAY(DATE(A1+A2,B1+B2,C1+C2))

But you get 4, not 5 for the day.

--
Kind regards,

Niek Otten

"an" wrote in message
...
Hello!

I have:

YY MM DD
2 9 20
4 3 15

I would like your help for the next result after sum periods:

YY MM DD
7 1 5

Thanks in advance.
an