Average if based on month date

[psrs0810]

I need to take an average of some trended data and I want the average to update based on a selected date.
So if the month listed is May, I need to be able average the months July - May. If that changes to June, I want the average to automatically change and average from July-June.
how do I set this up?
Thanks

 

[Saba Sabaratnam]

You could use AVERAGEIFS functions to average between range of dates as specified and demonstrated below.

Enter start month in B2
No of months for average in B3
and EOMONTH(B2,B3-1) in B4

Then you could refer B2 and (">="&B2) and B4 ("<="&B4") in AVERAGEIFS function.

Kind regards

Saba