COUNTIFS within a date range

I have a large worksheet with assignments over the course of months for multiple people. Some assignments are for more than one person.

I have built a formula that works for tracking assignments using the COUNTIF logic.
=COUNTIF({Written Budget - 2025 Offseason (2/17-8/31 Range 1}, HAS(@cell, Creator@row))

I'm now trying to build a formula to count assignments within the sheet by month for budget tracking purposes, so need to add a condition for the date. That appears in its own Run Date column.
I kept getting UNPARSEABLE errors, but finally got what I thought would work - but this returns a "0" for all results.

=COUNTIFS({Written Budget - 2025 Offseason (2/17-8/31 Range 1}, HAS(@cell, Creator@row), {Written Budget - 2025 Offseason (2/17-8/31 Range 3}, ">=03-01-2025", {Written Budget - 2025 Offseason (2/17-8/31 Range 3}, "<=03-31-2025")

What am I doing wrong?

Thanks,

Dan

Find more posts tagged with

Countif

Accepted answers

All comments

kira11

Hello,

It seems your Run Date column is the issue. Is it currently date format or text format? If it is a date data type you would need to get rid of the quotation marks and use the DATE() function.

sholmes

Hey, I was wondering if you could help me with the is blank formula. I am not sure what I am missing but I want it to ignore if the cell is blank. Here is what I am using:

=IF(ABS([Anticipated Fed TC (FM)]@row - [Federal Credits]@row) > 10, "Alert", "Ok", IF(ISBLANK)([Federal Credits]@row), "Ok")

Dkaufma106

@kira11 - thanks for this!

I am using the date formula in the Run Date column.

I updated the formula this way and still am getting "0" when I should be seeing data (see example) …

=COUNTIFS({Written Budget - 2025 Offseason (2/17-8/31 Range 1}, CONTAINS(@cell, Creator@row), {Written Budget - 2025 Offseason (2/17-8/31 Range 3}, >=DATE(2025, 3, 1), {Written Budget - 2025 Offseason (2/17-8/31 Range 3}, <=DATE(2025, 3, 31))

Appreciate any additional advice!

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.