Average formula - count dates

malky neiman

Hi,

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})

Paul Newcome

Are you getting an error or an unexpected number?

malky neiman

im getting the error of #invalid Operation

Paul Newcome

Try some "@cell" references.

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