I am trying to count thous cells which have status=Done and Date = Jun 2022 in google sheet. Here I made a formula but not getting proper count value
=COUNTIFS(J1:J20,"Done*",L8:L200,(ArrayFormula(month(L1:L20)),(MONTH(TODAY())-1)))
>Solution :
Try below formula-
=COUNTIFS(A2:A,"Done",B2:B,">=" & DATE(2022,6,1),B2:B,"<=" & EOMONTH(DATE(2022,6,1),0))
