Date Range and status formula

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

Find more posts tagged with

Formulas

Accepted answers

All comments

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

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.