looking between 2 dates as well a Start Date and End Date

Answers
-
Hello @Scott Peters - I was wondering if you could use this with looking between 2 dates as well a Start Date and End Date. Meaning COUNTIFS the DISTINCT SKU between 6/1/23 (Start Date) and 6/30/23 (End Date)?
=COUNTIFS(DISTINCT([Helper Join]:[Helper Join]), [COLUMN DATE], >= [Start Date]#, [COLUMN DATE], <=[End Date]#
Thank you for your help,
Michael
Michael Halvey
"Strive for Progress, not Perfection."
-
@MHalvey You would need to incorporate a COLLECT function (and the COUNTIFS won't work for this either).
=COUNT(DISTINCT(COLLECT([Helper Join]:[Helper Join], [COLUMN DATE]:[COLUMN DATE], >= [Start Date]#, [COLUMN DATE]:[COLUMN DATE], <=[End Date]#)))
-
Thank you @Paul Newcome - you are truly a genius!
Michael Halvey
"Strive for Progress, not Perfection."
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 430 Global Discussions
- 150 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 500 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!