I have a column of data covering 365 days, some of the cells have data and
some don't. I am trying to figure out how to calculate a 30 day moving
average ignoring blank cells. In other words, I want the average of the last
30 days that have a data value in the cell. The moving average may have to
look back at the last 50 to 60 days in order to get 30 days that have values
to average. I would appreciate any suggestions how to calculate this.
Bookmarks