COUNTIF Between Date Range

Hello,

I am trying to see how many projects were completed in in 2021. I have several different dates and years within the column, but I'm looking for a count of all projects with a 2021 date. The below formula is what I'm using but I am getting #UNPARSEABLE.

=COUNTIFS([NOC Recorded Date]:[NOC Recorded Date], >=DATE(2021, 1, 1) [NOC Recorded Date]:[NOC Recorded Date], <=DATE(2021, 12, 31))

I'd love help fixing if anyone can offer tips.

Find more posts tagged with

Formulas

Accepted answers

Jeff Reisman

Use the AND function to give it two criteria to analyze from one single range. The @cell reference evaluates every cell at once. You were also missing a comma between your range/criteria sets.

=COUNTIFS([NOC Recorded Date]:[NOC Recorded Date], AND(@cell >=DATE(2021, 01, 01), @cell <= DATE(2021, 12, 31)))

All comments

Jeff Reisman

Use the AND function to give it two criteria to analyze from one single range. The @cell reference evaluates every cell at once. You were also missing a comma between your range/criteria sets.

=COUNTIFS([NOC Recorded Date]:[NOC Recorded Date], AND(@cell >=DATE(2021, 01, 01), @cell <= DATE(2021, 12, 31)))

KristiTRUSD

@Jeff Reisman thank you for your help! That worked perfectly for me.

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.