Forum Discussion
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.
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))
=AVERAGE(INDEX(--SUBSTITUTE(B2:B101,"MONTH",""),0))