I'd add a separate column that returns the number of months using DATEDIF with \"M\" as third argument.\n Let's say the results are in M2:M50.\n Then use\n\n =QUOTIENT(SUM(M2:M50), 12)& \" Years, \"&MOD(SUM(M2:M50),12)& \" Months\"","body@stringLength":"487",...
For example I would like to add 22 Years 5 Months, to 5 years 6 months. NeilRoback 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, "&...
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:...