Excel Formulas

Copper Contributor
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.
2 Replies

@Mihnea1923 

Because of &"MONTH" in your formula the result is text. And text is ignored in AVERAGE().

Solution: Remove &"MONTH" from you formula.

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))