Date Range and status formula

Aimee Colton

Hello,

I have a metric sheet where I am trying to build a formula that references a date range column and status column of another sheet, but I keep getting "unparseable" or "incorrect argument".

I have tried the following formulas:

=COUNTIFS({Event Date},>=(2024, August, 1),{Event Date}, <(2025, August, 1),{Event Status},"Advice only") UNPARSEABLE

I don't know if it matters that my date column is formatted like this: Monday, November 1, 2024.

I tried changing the format to 2024-11-01 and used this formula

=COUNTIFS({Status}, "Advice only", {Event Date}, >=DATE(2024 - 8 - 1), {Event Date} <= DATE(2025 - 7 - 31)) INCORRECT ARGUMENT

Could someone advise

Michelle Choate 2

Try this: COUNTIFS({Events Date}, >=DATE(2024,08,01),{Events Date}, <DATE(2025,08,01, {Event Status}, "Advice Only")

Aimee Colton

Hi Michelle,

I get #INCORRECT ARGUMENT

Georgie

Hi @Aimee Colton,

It looks like the closing bracket is missing after the second DATE function from the formula @Michelle Choate 2 provided - try:

• =COUNTIFS({Events Date}, >=DATE(2024,08,01),{Events Date}, <DATE(2025,08,01), {Event Status}, "Advice Only")

Does that work?

Georgie