To SUM dates (exclusive the duplicated ones)

[dcyuen]

Hey guys,
I want to count how many days I have worked. The total would be 4 for the following but how does the formula looks like? I cannot figure out how to avoid counting the duplicated ones. Thanks.

Worked date
19-Mar
19-Mar
19-Mar
14-Mar
15-Mar
28-Mar

-Donald

 

[Aladin Akyurek]

Control+shift+enter, not just enter:

=SUM(IF(FREQUENCY(IF(A2:A7<>"",MATCH("~"&A2:A7,A2:A7&"",0)),ROW(A2:A7)-ROW(A2)+1),1))

Hey guys,
I want to count how many days I have worked. The total would be 4 for the following but how does the formula looks like? I cannot figure out how to avoid counting the duplicated ones. Thanks.

Worked date
19-Mar
19-Mar
19-Mar
14-Mar
15-Mar
28-Mar

-Donald

 

[dcyuen]

Thanks!