COUNTIFS including the Month within the Modified Column

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

Find more posts tagged with

Accepted answers

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.