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

System

This discussion was created from comments split from: Countifs and Distinct.

MHalvey

https://community.smartsheet.com/discussion/comment/344508#Comment_344508

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

Paul Newcome

@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]#)))

MHalvey

Thank you @Paul Newcome - you are truly a genius!

Paul Newcome

Happy to help. 👍️