Create metrics using a Date Range

Hello - I am trying to build metrics that show how many projects are created with specific quarters based off a Date completed column. Currently using this formula but it is not working:

=COUNTIFS({Project List Range 1}, "Closed", {Project List Range 3}, >=DATE(2020, 1, 1) <= DATE(2020, 3, 31))

Any helpful tips would be appreciated. The 1st argument is pulling data from a status column. When the project moves to closed, want to calculate how many projects closed within quarter 1, quarter 2, etc.

Thanks in advance

Find more posts tagged with

Accepted answers

Paul Newcome

Try this slight adjustment...

=COUNTIFS({Project List Range 1}, "Closed", {Project List Range 3}, AND(@cell >= DATE(2020, 1, 1), @cell <= DATE(2020, 3, 31)))

All comments

Paul Newcome

Try this slight adjustment...

=COUNTIFS({Project List Range 1}, "Closed", {Project List Range 3}, AND(@cell >= DATE(2020, 1, 1), @cell <= DATE(2020, 3, 31)))

Shane Cornwell

Thanks Paul that did the trick. Really appreciate the assistance.

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.