Forum Discussion
jaredcott6
May 02, 2023Copper Contributor
Automate an averaging formula by date
Hello, I am running into an issue with a spreadsheet I am currently working on. I have data from the last 30 days and need to figure out how to insert the date into the function without manually doin...
- May 02, 2023
If you want to average over the last 30 days, use
=AVERAGEIFS(average_range, date_range, ">"&TODAY()-30, date_range, "<="&TODAY())
HansVogelaar
May 02, 2023MVP
If you want to average over the last 30 days, use
=AVERAGEIFS(average_range, date_range, ">"&TODAY()-30, date_range, "<="&TODAY())
jaredcott6
May 05, 2023Copper Contributor
Thank you! That worked perfectly