DATE Function

Question

I am wanting to count how many open and on-hold calls I have open over a month using the date function.

I have 2 Columns as helpers "SD" & "ED" SD is static and selects the first date via the Calendar and ED which gets the last date using the SD column

ED -Formula:

=IFERROR(DATE(YEAR(SD@row), MONTH(SD@row) + 1, 1), DATE(YEAR(SD@row) + 1, 1, 1)) - 1

But I cannot get the DATE function to work for the count if i enter the dates manually its fine.

=COUNTIFS({IT Faults In-Progress}, 1, {IT Faults Date}, @cell  >= DATE(2026, 3, 1), {IT Faults Date}, @cell  <= DATE(2026, 3, 31))

The things I have tried to accomplish this.

* Mirror the 2026,3,1 using Mid function
* Use Helper columns and have the "yr, m, d" in separate columns 
*  tired to use the below formula to generate the required values

=IFERROR(DATE(YEAR(SD@row), MONTH(SD@row) + 1, 1), DATE(YEAR(SD@row) + 1, 1, 1)) - 1

Drawn blanks on all my options

Below is a image of the sheet and the mess is all my testing 😁

Paul Newcome · Answer

Sorry about that. I missed a closing parenthesis.

=COUNTIFS({IT Faults In-Progress}, @cell = 1, {Date Column}, AND(IFERROR(MONTH(@cell), 0) = MONTH(SD@row), IFERROR(YEAR(@cell), 0) = YEAR(SD@row)))

Hargreaves · Answer

Hi Paul, Using your formula:

=COUNTIFS({IT Faults In-Progress}, @cell  = 1, {IT Faults Date}, AND(IFERROR(MONTH(@cell ), 0 = MONTH(SD@row), IFERROR(YEAR(@cell ), 0) = YEAR(SD@row))))

I get error "incorrect argument set"

Paul Newcome · Answer

That error comes from a {Cross Sheet Reference} being typed but not created. Make sure each of the {Cross Sheet References} have been created properly.