Forum Discussion
Formula to count dates that sometimes repeat
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 with...
Depends on you Excel version/platform. As variant that could be like =COUNT( UNIQUE( dates ) )