Forum Discussion
Calculate average between multiple timeframes
I have the following timeframes I calculated. I am trying to now calculate the average between all the dates and I cannot figure out the formula. Can anyone assist? 3 yr, 8 mo 5 yr, 1 mo 1 yr, ...
As a comment, if dates are named range ages,
formula for average could be
=AVERAGE( LEFT(ages, FIND(" yr", ages) ) + SUBSTITUTE( RIGHT(ages, LEN(ages) - FIND(", ", ages) - 1 ), " mo", "")/12 )transform to text with yr and mo as Riny_van_Eekelen suggested