Forum Discussion

Copper Contributor

May 11, 2019

Excel Formulas

Hi. I want to do average to a column(B) of date. It doesn t work just with average. The column of date has the follow formulas: DATEDIF.

Twifoo
Silver Contributor
May 11, 2019
If your data starts in Row 2, you may use this formula to remove the text "MONTH" and obtain the average:
=AVERAGE(INDEX(--SUBSTITUTE(B2:B101,"MONTH",""),0))
Detlef_Lewin
Silver Contributor
May 11, 2019
Mihnea1923
Because of &"MONTH" in your formula the result is text. And text is ignored in AVERAGE().
Solution: Remove &"MONTH" from you formula.