COUNTIFS including the Month within the Modified Column

avoed

Hi, I'm working on a dashboard that tracks monthly completed tasks for staff members, based on a Modified date column. I'm using a COUNTIFS formula to filter based on the 4 filters. Can someone help me figure out the error(s) in my formula? Currently says it is an Invalid Data Type.

=COUNTIFS({Incoming Grid Range 4}, ="Standard", {Incoming Grid Range 2}, ="Staff Name", {Incoming Grid Range 3}, ="Yes", {Incoming Grid Range 5}, >=DATE(2025), MONTH(1))

Jason Tarpinian

Your 4th range is not correct. Are you saying only dates that are after January 2025 or after? That would be written as:

>=DATE(2025, 1, 1)

avoed

I'm look for only dates within each month, January in this instance. I revised my formula but it's showing 0 when I know it should say 19. Does it matter that my modified column is date & time stamped?

=COUNTIFS({Incoming Grid Range 4}, ="Standard", {Incoming Grid Range 2}, ="staff name", {Incoming Grid Range 3}, ="Yes", {Incoming Grid Range 5}, ="DATE(2025, 1, 1), MONTH(1)")

avoed

I've corrected my formula and wanted to share how it worked:

=COUNTIFS({Incoming Grid Range 4}, ="Standard", {Incoming Grid Range 2}, ="Staff Name", {Incoming Grid Range 3}, ="Yes", {Incoming Grid Range 5}, >=DATE(2025, 1, 1), {Incoming Grid Range 5}, <=DATE(2025, 1, 31))

Revising the dates by month as needed.