I'm trying to find the number of cells that meet a criterion within a specific date window.

Maxwony

=COUNTIFS({Access Request Range 5},>=(2021, 7,1),{Access Request Range 5}, <=(2021,9,30), {Access Request Range 2},"Approved")

Maxwony

I found it. there was a ")" missing.

=COUNTIFS({Access Request Range 5}, AND(@cell >= DATE(2021, 7, 1), @cell <= DATE(2021, 9, 30)), {Access Request Range 2}, "Approved")

Jason Duryea

Try this...

=COUNTIFS({Access Request Range 5}, AND(@cell >= DATE(2021, 7, 1), @cell <= DATE(2021, 9, 30), {Access Request Range 2}, "Approved")

Maxwony

I now have an error for the data type

I'm referencing a separate sheet. Trying to get a count of the statuses marked "Approved" within the 3rd quarter of the year based on their date submitted (7/01/2021 to 9/30/2021)

Maxwony

I found it. there was a ")" missing.

=COUNTIFS({Access Request Range 5}, AND(@cell >= DATE(2021, 7, 1), @cell <= DATE(2021, 9, 30)), {Access Request Range 2}, "Approved")