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

She18ee

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

She18ee

Figured it out thank you!

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)))