CountIf with Date ranges

Trying to write a formula that counts the number of instances based on a date range. I can get the instances to populate in a formula by themselves but I cannot get the date range to work?

This is weird as the formula works in another sheet for another scenario.

=COUNTIFS({CURRENT CHECKOUT SCENARIO Range 1}, [Primary Column]@row, {CURRENT CHECKOUT SCENARIO Range 2}, AND(@cell >= DATE(1965, 1, 30), @cell <= DATE(2021, 4, 30)))

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Are you getting an error or an incorrect count?

Genevieve P.

Hi @JScot

Can you clarify what you mean when you say you can't get it to work? Are you receiving an error or an incorrect result? The structure of the formula is correct, so it may be that there's an issue with the ranges or the criteria.

Check to make sure that your "Range 2" is looking at a Date Type of column. If it is, could you post screen captures of each range and the current sheet (but please block out sensitive data).

Thanks!

Genevieve

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.