Running average formula?

Hello everyone,

Basically, Im trying to update my spreadsheet daily with an average of the last 7, 30, and 90 days worth of data in columns without having to manually update the formula.

Any suggestions?

Thanks!

Maybe like this:

=AVERAGE(IF(TODAY() - A1:A100 <= 7, B1:B100) )

This is an array formula, meaning it MUST be confirmed with Ctrl+Shift+Enter, not just Enter. (With the cursor in the formula bar, hold down Ctrl and Shift, then press Enter.) You'll know you did it correctly if curly braces appear around the formula in the Formula Bar; you cannot type in the braces directly.

Thanks! I'll try this. I really appreciate it!