=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