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, ...
usernam123 How did you calculate these "timeframes"? If you could work with real numbers, it would be a lot easier. For instance, you could calculate 3.66667 in one cell and make it look like "3 yr, 8 mo" in another. Something like this:
The formula in C3 (and copied down) is:
=INT(B3)&" yr, "&TEXT(MOD(B3,1)*12,"0")&" mo"B7 contains:
=AVERAGE(B3:B5)
- I used the DATEDIF function. I understand it would be easier with real numbers which is why I am asking if anyone knows another way.
Do you have start dates and end dates? Or did you uses start dates and TODAY()?
- the first start is a start date and the second date is TODAY()
