Forum Discussion

jaredcott6's avatar
jaredcott6
Copper Contributor
May 02, 2023
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...
  • HansVogelaar's avatar
    May 02, 2023

    jaredcott6 

    If you want to average over the last 30 days, use

     

    =AVERAGEIFS(average_range, date_range, ">"&TODAY()-30, date_range, "<="&TODAY())

Resources