COUNTIFS with Specific Dates

Jesse Willis

I'm working on a Pre-COVID and COVID list and could use some help. Can someone take a look?

One example: We need to COUNT how many times TRB was used during the dates of January 1st, 2020 to March 13, 2020.

=COUNTIFS(Division:Division, CONTAINS("TRB", @cell)), ([EventDate, >DATE(2020, 1, 1):EventDate, <DATE(2020, 3, 13)])

Find more posts tagged with

Accepted answers

Mark Cronk

Hi @Jesse Willis ,

Try:

=COUNTIFS(Division:Division, CONTAINS("TRB", @cell)), [EventDate]:[eventdate], >DATE(2020, 1, 1), [EventDate]:[eventdate], <DATE(2020, 3, 13)])

Mark

All comments

Mark Cronk

Hi @Jesse Willis ,

Try:

=COUNTIFS(Division:Division, CONTAINS("TRB", @cell)), [EventDate]:[eventdate], >DATE(2020, 1, 1), [EventDate]:[eventdate], <DATE(2020, 3, 13)])

Mark

Jesse Willis

Thanks Mark!

I used the following that worked beautifully!

=COUNTIFS({Complex Virtual Meeting Support Request Range 1}, =Division@row, {Zoom Webinar -Report Range 1}, >=DATE(2020, 1, 1), {Zoom Webinar -Report Range 1}, <=DATE(2020, 3, 13))

Mark Cronk

Happy to help. Thank you for using the Community.

Be Well,

Mark

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