COUNTIFS with Date range with @row

I have the current formula that counts the start date but I wanted to see if i could do a range of dates from start date to end date and count those. Any Advice?

=COUNTIFS([Staff Team]:[Staff Team], [Staff Team]@row, [Start Date]:[Start Date], [Start Date]@row)

Find more posts tagged with

Formulas

Accepted answers

Krissia B.

Hello @Christopher Neal

It looks like you would be looking for something like this:

=COUNTIFS([Staff Team]:[Staff Team], [Staff Team]@row, [Start Date]:[Start Date], >=[Start Date]@row,[End Date]:[End Date],<=[End Date]@row)

This would return the number of records for the Staff Team of that row; that have a Start Date >= the Start Date of that row, and an End Date >= the End Date of that row.

Hope this helps!

Let me know if I have misunderstood your question!

Cheers~

Krissia

All comments

Krissia B.

Hello @Christopher Neal

It looks like you would be looking for something like this:

=COUNTIFS([Staff Team]:[Staff Team], [Staff Team]@row, [Start Date]:[Start Date], >=[Start Date]@row,[End Date]:[End Date],<=[End Date]@row)

This would return the number of records for the Staff Team of that row; that have a Start Date >= the Start Date of that row, and an End Date >= the End Date of that row.

Hope this helps!

Let me know if I have misunderstood your question!

Cheers~

Krissia

Christopher Neal

That worked perfectly thanks!

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