I collect data every weekday, and I'm trying to find the average of each day but am encountering the Div/0 error because Excel only sees the date information and not the day formatting. (See attachment).
So, I want the average of Monday data, Tuesday data, etc. Is there a way to do this?
Bookmarks