Forum Discussion

ConneV's avatar
ConneV
Copper Contributor
Jan 25, 2022

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 within the column.

 

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    ConneV 

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

Resources