COUNT DISTINCT Using Dates

Peta

I'm trying to count how many days in a set of data based on criteria of other columns, yet it's returning an answer for the entire sheet instead of the selected IF range.

I've tried =COUNT(DISTINCT(Date:Date), IF([Year / Month]:[Year / Month] = [Date Field for Klipfolio]@row))

My aim is count unique dates from "Date" column, when "Year / Month" column = "[Date Field for Klipfolio]2541". So as example in the screenshot the formula should return 5.

Please advise what I'm doing wrong with my formula.

Thanks

Paul Newcome

Try this...

=COUNT(DISTINCT(COLLECT(Date:Date, [Year / Month]:[Year / Month], @cell = [Date Field for Klipfolio]@row)))

Paul Newcome

Try this...

=COUNT(DISTINCT(COLLECT(Date:Date, [Year / Month]:[Year / Month], @cell = [Date Field for Klipfolio]@row)))

Peta

Yes it worked! Thank you @Paul Newcome

Paul Newcome

Happy to help. 👍️