COUNTIFS from one date through today with other criteria

Hello!

Needing help creating a formula. The formula has to count all the cells in the "clearance date" column that are blank with the criteria from the "application effective date" which is all dates happening 10.1.2021 through today (which means counting on a rolling basis)

I have this formula below that isn't working:

=COUNTIFS({Clearance Date Range 2}, "", {Application Effective Date Range 1}, AND(@cell >= 2021.10.1))

Any help appreciated!

Find more posts tagged with

Formulas

Accepted answers

All comments

Genevieve P.

Hi @JamieH

Instead of writing out the date as a text string, you'll want to use the DATE function so the formula recognizes what numbers represent the day/month/year, etc.

Try something like this:

=COUNTIFS({Clearance Date Range 2}, "", {Application Effective Date Range 1}, @cell >= DATE(2021, 10, 01))

See: DATE Function

Cheers,

Genevieve

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.