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
|