Hello! I am trying to make a graph with these dates!

I am using a Grid Sheet and a reference sheet but can not figure out how to get the formula to match. I am using

=COUNTIFS([Start Date]:[Start Date], AND(@cell >= DATE (2021, 1, 1), @cell <= DATE(2021, 12, 31)))

This is my reference sheet formula

=COUNTIFS({OnBoarding Partner Agreements Range 1} [Start Date]:[Start Date], ">="&DATE(2021, 1, 1), {OnBoarding Partner Agreements Range 1} [Start Date]:[Start Date], "<="&DATE(2021, 12, 31))

But I am wondering how I pull this from another sheet and put this in a reference sheet to make a bar graph

TYIA

Find more posts tagged with

Accepted answers

She18ee

Figured it out thank you!

All comments

She18ee

Figured it out thank you!

Georgie

Hey @She18ee,

I'm glad you were able to get this resolved! Would you be happy to post your solution to help other members reviewing this thread?

Thanks,

Georgie

She18ee

I was not able to put it in a reference sheet but I did figure out the formula I needed and just put it below!

=COUNTIFS([Start Date]:[Start Date], AND(@cell >= DATE (2021, 1, 1), @cell <= DATE(2022, 12, 31)))

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.