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.
Because of &"MONTH" in your formula the result is text. And text is ignored in AVERAGE().
Solution: Remove &"MONTH" from you formula.