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, ...
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()
See the attached sample workbook for a way to calculate the average.