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 variant for HansVogelaar sample
=INT( AVERAGE( TODAY() - A2:A25)/365.25 ) & " yr, " & ROUNDDOWN( MOD( AVERAGE( TODAY() - A2:A25)/365.25, 1 )*12, 0 ) & " mo"