How to combine AVG and TODAY Function

tmagana

I want to take the AVG of that column but only take the past 30 days from another column.

Thanks in advance for any help😊

Paul Newcome

You would use an AVG/COLLECT combo.

=AVG(COLLECT({Range To Average}, {Date Range}, @cell>= TODAY(-30)))