I have an AVERAGEIF formula that searches the data for a given hour, across an entire year. Works great. I would like that formula to also tell me the average across the last two months, and I would like it to update automatically as the year progresses and I enter new data. As it stands, I have to change the reference column manually (date’s run across in columns).

Is there a way to make the column portion of AVERAGEIF change in response to the value of =TODAY?

Thanks!

​I have an AVERAGEIF formula that searches the data for a given hour, across an entire year. Works great. I would like that formula to also tell me the average across the last two months, and I would like it to update automatically as the year progresses and I enter new data. As it stands, I have to change the reference column manually (date’s run across in columns). Is there a way to make the column portion of AVERAGEIF change in response to the value of =TODAY? Thanks!  Read More

​