Hi,

I have a column A with dates that occurs more than one time.

I would like to count them and then show the result as shown to the right.

I've tried to use "COUNTIF", but I'm not sure what I do wrong.

Thanks in advance

It looks like the values aren't real dates but text strings that look like dates, witness the green error triangles in the upper left corner of the cells.

Nonetheless, a formula such as

=COUNTIF($A$1:$A$500,E1)

should work (you can adjust the range $A$1:$A$500 as needed). The formula can be filled.

A potential problem with the text values is that there could be trailing soft or hard spaces - make sure there is nothing after the 14 in the cells.