Counting items within a date range

Hi,

I am trying to count the number of requests whose status is closed, and that were initially opened (Request Date) in the month of September 2019 (see extract of the table)

Hereunder is my table:

Here is the formula that I entered, and generates a "#UNPARSEABLE" message:

=COUNTIFS({Report Status}, "Closed", AND(@{Request Date} >= DATE(2019, 9, 1), @{Request Date} <= DATE(2019, 9, 30)))

Thanks for your help.

Manuel

Find more posts tagged with

Accepted answers

Paul Newcome

Try this:

=COUNTIFS({Report Status}, "Closed", {Request Date}, AND(IFERROR(MONTH(@cell), 0) = 9, IFERROR(YEAR(@cell), 0) = 2019))

All comments

Paul Newcome

Try this:

=COUNTIFS({Report Status}, "Closed", {Request Date}, AND(IFERROR(MONTH(@cell), 0) = 9, IFERROR(YEAR(@cell), 0) = 2019))

Manuel Chowrimootoo

Hi Paul,

Thank you so much.

I overlooked at the 'IFERROR' and to call in the month and then the year.

Thanks again.

Paul Newcome

Happy to help! 👍️

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.