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

malky neiman

Im circling back on this. i cant get it to work. i have this:

=AVERAGEIF({Date Applied}, AND(@cell >= DATE(2023, 11, 11), @cell <= DATE(2023, 11, 17)), {HR review time})

the references are being referenced across sheets. (if that makes a difference. ) im getting #incorrect Argument Set

Paul Newcome

Make sure your ranges are both set up to each be whole single columns by clicking on the appropriate column header when creating the cross sheet references.