Count if Specific Text within a Date Range

I'm trying to create a formula to count a specific text within a column only when it's during a specific date range. I can't figure out where my error is.

=COUNTIFS([Branch Selected]:[Branch Selected], "East Branch", [Date]:[Date], >= [2020-08-01], [Date]:[Date], <=[2020-08-31])

Find more posts tagged with

Formulas

Accepted answers

David Joyeuse

Hi @Stacy Hammons

You can try this:

=COUNTIFS([Branch Selected]:[Branch Selected], "East Branch", [Date]:[Date], MONTH(@cell)=8)

Hope it helped!

Sean Morgan

Hello @Stacy Hammons ,

I was able to replicate the error you are facing when the Date Column was a Text/Number type, rather that a Date type, but I was also able to have the above Formula return a result when having the Date Column as a Date Type.

With this, you may want to view the Properties of your Column named Date to verify this is a Date type.

Kindest Regards

Sean

Stacy Hammons

Thank you @Sean Morgan. I checked that. After digging a little deeper I think my problem is how it flows into the worksheet. It's not picking the date up as a date. I will reach out to get this fixed.

All comments

David Joyeuse

Hi @Stacy Hammons

You can try this:

=COUNTIFS([Branch Selected]:[Branch Selected], "East Branch", [Date]:[Date], MONTH(@cell)=8)

Hope it helped!

Stacy Hammons

@David Joyeuse Thanks, I tried that and it didn't work. It says Invalid data type. My form format is 2020-09-28. Would that make a difference?

Sean Morgan

Hello @Stacy Hammons ,

With this, you may want to view the Properties of your Column named Date to verify this is a Date type.

Kindest Regards

Sean

Stacy Hammons

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.