Average formula - count dates



I have a column named "Applied" which has dates of when an application was submitted. there is another column called "HR Review Time". the HR review time has numbers. i want to make an AVERAGE of the number in the hr review time column for dates 11/11/23 until 11/10/23 in the applied column

I created this formula but its not working. what am i doing wrong?

=AVERAGEIF({Applied}, AND(>=DATE(2023, 11, 11), <=DATE(2023, 11, 17)), {HR Review Time})


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!