Forum Discussion
Anonymous
Apr 26, 2017Dates formula
I am trying to count the number of individual dates within a specific date ranges (the dates relates to the date a person attended a client). Have tried with the countif and if formula but not succe...
SergeiBaklan
Apr 26, 2017Diamond Contributor
Hi Wendy,
The approach how to count distinct number of dates (or whatever) is described here
https://exceljet.net/formula/count-unique-values-in-a-range-with-countif
if with criteria
https://exceljet.net/formula/count-unique-text-values-with-criteria