Feb 22 2024 11:10 AM
I am attempting to calculate the average n of days for x amt of cells that has a formula currently set to calculate n in days.
i.e column n calculates =DATEDIF(B124,F124,"D")&" days " - the data is pulled from B2:124,F2:124. I now need to calculate the AVG N of days from Column N2 to N124 - formatted in days. However, I keep getting the #DIV/0! error.
I definitely didn't go to school far data collection, but it's something that I was recently asked to do by my employer. I've looked at youtube videos and searched the web and I still don't understand what I am doing wrong/how to fix the formula.
Any help is appreciated!
Feb 22 2024 12:14 PM
Because of the &"days" part, the formulas in column N return a text value.
AVERAGE ignores all text values.
Change the formula to =DATEDIF(B124,F124,"D")
Feb 22 2024 12:19 PM
I can't believe it was that easy of a fix! Thank you, so much, for helping!!@HansVogelaar