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
|