I am trying to count the number of tickets between dates that are client facing only; everything i've researched brings me back to this formula, however I keep getting #UNPARSED and i cant figure out what is wrong
=COUNTIFS({ReportedDate}, ">="&DATE(2026,4,1), {ReportedDate}, "<"&DATE(2026,7,1), {Category}, "Client-Facing")
There are no blank cells, so nothing to account for there. My Date column is set as Date.
Update: I fixed the error, however, its coming back with 0 as my result which is not accurate
=COUNTIFS({ReportedDate}, <=DATE(2026, 4, 1), {ReportedDate}, >=DATE(2026, 7, 1), {Category}, "Client-Facing")
