Forum Discussion
Solved
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...
If you want to average over the last 30 days, use
=AVERAGEIFS(average_range, date_range, ">"&TODAY()-30, date_range, "<="&TODAY())
If you want to average over the last 30 days, use
=AVERAGEIFS(average_range, date_range, ">"&TODAY()-30, date_range, "<="&TODAY())
Thank you! That worked perfectly