英文:
MS Excel formula for computing total in years, months, and days
问题
如何计算给定快照的年月日总数。
英文:
How do I calculate the total of Year Month and Days as given snapshot.
答案1
得分: 2
以下是翻译好的部分：
For days =MOD(SUM(D2:D7),30) <br>
For months =MOD(SUM(C2:C7)+INT(SUM(D2:D7)/30),12) <br>
For years =SUM(B2:B7)+INT((INT(SUM(D2:D7)/30)+SUM(C2:C7))/12)
英文:
As per comment try following formulas.
For days =MOD(SUM(D2:D7),30) <br>
For months =MOD(SUM(C2:C7)+INT(SUM(D2:D7)/30),12) <br>
For years =SUM(B2:B7)+INT((INT(SUM(D2:D7)/30)+SUM(C2:C7))/12)
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论