Computing the average based on the last 90 days.

[Mia Story]

A formula that automatically computes the last 90 days based on today's date. Each day, a new deposit value is added, the column begins from the 1st of the year.
The formula should compute the average of =today()-90.

 

[etaf]

=AVERAGEIF(C:C,">="&TODAY()-90,D:D)
where C is the column with dates
D is the column you want to average
so change those reference to match your data

=AVERAGEIF(Criteria Range,">="&TODAY()-90,Range to Average )

 

[Mia Story]

=AVERAGEIF(C:C,">="&TODAY()-90,D:D)
where C is the column with dates
D is the column you want to average
so change those reference to match your data

=AVERAGEIF(Criteria Range,">="&TODAY()-90,Range to Average )

Hi Etaf,
Thank you for formula!!! I work with so many files and this formula will save a significant amount of time. Have a great day.

 

[etaf]

you are welcome