COUNTIFS within a date range

Dkaufma106

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

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!