Jan 25 2022 11:42 AM
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.
Jan 25 2022 11:50 AM
Depends on you Excel version/platform. As variant that could be like =COUNT( UNIQUE( dates ) )