How do I add a date range formula to an existing formula?
This is the formula I have built so far:
=COUNTIFS({EP DAR Data Input Tracker - Sheet (with Fo Range 1}, {EP DAR Data Input Tracker - Sheet (with Fo Range 2}) & "," AND({EP DAR Data Input Tracker - Sheet (with Fo Range 4}, ">=2025-01-01",{EP DAR Data Input Tracker - Sheet (with Fo Range 4}, "<=2025-31-01")
Answers
-
It looks like you are using Excel syntax. Try this instead (to include each @cell reference being left as is):
=COUNTIFS({EP DAR Data Input Tracker - Sheet (with Fo Range 4}, IFERROR(YEAR(@cell), 0) = 2025)
I removed the first two {Ranges} because you have no criteria for either of them. What is the purpose of those two ranges?
-
Hello Paul -
What I am trying to do is pull information from a data input tracker column to be tracked by the date. I have a form setup that tracks all the data and one of the entries in the columns is dates.
For instance… if said column has multiple allowable entries from a form (Billy or Joe) I want to know how many times Billy was selected in that column and if it was between 01/01/2025 and 01/31/2025. -
If using the above data, the formula/data I want to track is the following:
How many times did Billy use the Honda Vehicle in the month of January?
How many times was there single coverage in the month of January? -
In that case you would use the standard COUNTIFS (the one the the "S" on the end) syntax.
=COUNTIFS({Range 1}, criteria 1, {Range 2}, criteria 2, {Range 3}, criteria 3)
.
-
Hey Paul -
I was able to create the formula that I was looking for which is the below:
=COUNTIFS({Logged By}, {Billy}, {Date Collected}, AND(@cell >= DATE (2025, 2, 1), @cell <= DATE(2025, 2, 28)))
Now i would like to utilize that same count/date range but add in to the formula how many times Billy used the Honda.In summary - How many times Billy was the person who logged the information in the month of January for using the Honda.
-
You would just need to add another range/criteria set following the same syntax outlined above.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!