Average IF Within 30 days

Julie Boss

Hello,

I am trying to figure out a formula to average a particular column of information, but only within the last 30 days. I have a "Todays Date" Formula/column already created, but not sure how to write the formula to be able to read my whole column of data but only pull from the past 30 days.

I appreciate any help in advance.

Thank you,

Paul Newcome

Try something similar to...

=AVG(COLLECT([Column to Average]:[Column to Average], [Date Column]:[Date Column], AND(@cell >= TODAY(-30), @cell <= TODAY()))

Paul Newcome

Try something similar to...

=AVG(COLLECT([Column to Average]:[Column to Average], [Date Column]:[Date Column], AND(@cell >= TODAY(-30), @cell <= TODAY()))

Julie Boss

That worked perfectly. Thank you Paul!

Paul Newcome

Happy to help! 👍️