从月日格式的年龄计算年龄平均值 [英] Calculate age average from age in month day format

问题描述

我的月份日期格式如下：

I have ages in month.day format like this:

35,24
36,11
36,19
37,18
35,12
37,04
35,20
36,01
35,26
36,05
36,16
37,28

例如第一次入学，年龄为35个月和24天。
如何平均使用相同格式的平均值？

for example for the first entry, the age is 35 months and 24 days. How can I average them all to get a proper age average in the same format?

谢谢

推荐答案

如果可以合理地假定月份等于30天，那么以下内容将以 mm，dd的形式返回平均值

If it can be reasonably assumed that a month is equal to 30 days then the following will return an average in the form of mm,dd.

=INT((SUMPRODUCT(LEFT(A2:A13, FIND(",", A2:A13)-1)*30+MID(A2:A13, FIND(",", A2:A13)+1, 99))/ROWS(A2:A13))/30)&
  ","&
  INT(MOD((SUMPRODUCT(LEFT(A2:A13, FIND(",", A2:A13)-1)*30+MID(A2:A13, FIND(",", A2:A13)+1, 99))/ROWS(A2:A13)),30))

这篇关于从月日格式的年龄计算年龄平均值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！