Formula to COUNTIF with respect to the date column

These two formula are not working - ERROR - #unparseable. The solution I am looking for is to count the no. of MOUs in a calendar year (YTD 2023).

=COUNTIFS({MOU Status}, "Active", {Date of execution}, (@cell >= DATE(2023, 1, 1), @cell <= DATE(2023, 12, 31)))

=COUNTIFS({MOU Status}, "Active", {Date of execution}, >=DATE(2023, 1, 1), {Date of execution}, <=DATE(2023, 12, 31)))

Please help and suggest an alternative solution.

Find more posts tagged with

Accepted answers

All comments

Nick Korna

Hi @SiddV47,

You just need to add an AND function to the first formula as you have 2 date criteria:

=COUNTIFS({MOU Status}, "Active", {Date of execution}, AND(@cell >= DATE(2023, 1, 1), @cell <= DATE(2023, 12, 31)))

The # unparseable error is being caused as without the AND the 2nd date criteria is being read as a range (which it isn't), lacking any criteria.

Hope this resolves your issue, but if not let us know!

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.