For example I would like to add 22 Years 5 Months, to 5 years 6 months. I'd add a separate column that returns the number of months using DATEDIF with "M" as third argument. Let's say the results are in M2:M50. Then use =QUOTIENT(SUM(M2:M50), 12)& " Years, "&MOD(SUM(...
For example I would like to add 22 Years 5 Months, to 5 years 6 months. I'd add a separate column that returns the number of months using DATEDIF with "M" as third argument. Let's say the results are in M2:M50. Then use =QUOTIENT(SUM(M2:M50), 12)& " Years, "&MOD(SUM(M2:...