Formula to calculate # of Projects per Month

So I keep getting #unparseable from my formula below.

=COUNTIFS({Creative Marketing Request Tracker Range 5}[Start Date]:[Start Date], <=DATE(2025, 11, 30), [End Date]:[End Date], >=DATE(2025, 11, 1))

I have a lot of projects with different "Requested Delivery Date" (column header). Above I attempted to find how many projects are in November.

Note that the Requested Delivery Date column type is set to Date. Appreciate any help!

Find more posts tagged with

Accepted answers

All comments

Philip Robbins

@WBStambl you appear to be missing a comma after {Creative Marketing Request Tracker Range 5}. Drop one in and see if that fixes it for you.

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.