Formula to count dates that sometimes repeat

Copper Contributor

I am looking for a formula that will count the total days in a column of dates but there are multiples of the same dates. I want to know the total days in the column without the doubles of dates within the column.


1 Reply


Depends on you Excel version/platform. As variant that could be like =COUNT( UNIQUE( dates ) )