Count dates

[johannordgren]

Hello there!

This question seems really stup, but I can't seem to figure it out, and I actually don't find a thread about it..

I want to count the times each date is recorded in a column.
Ex:
2018-05-21: 15 times
etc.

Thanks in advance!

The column looks like this:
[TABLE="width: 133"]
<tbody>[TR]
[TD]Dates[/TD]
[/TR]
[TR]
[TD="align: right"]2018-05-21[/TD]
[/TR]
[TR]
[TD="align: right"]2018-05-21[/TD]
[/TR]
[TR]
[TD="align: right"]2018-05-21[/TD]
[/TR]
[TR]
[TD="align: right"]2018-05-21[/TD]
[/TR]
[TR]
[TD="align: right"]2018-05-21[/TD]
[/TR]
[TR]
[TD="align: right"]2018-05-21[/TD]
[/TR]
[TR]
[TD="align: right"]2018-05-21[/TD]
[/TR]
[TR]
[TD="align: right"]2018-05-21[/TD]
[/TR]
[TR]
[TD="align: right"]2018-05-21[/TD]
[/TR]
[TR]
[TD="align: right"]2018-05-21[/TD]
[/TR]
[TR]
[TD="align: right"]2018-05-21[/TD]
[/TR]
[TR]
[TD="align: right"]2018-05-21[/TD]
[/TR]
[TR]
[TD="align: right"]2018-05-21[/TD]
[/TR]
[TR]
[TD="align: right"]2018-05-19[/TD]
[/TR]
[TR]
[TD="align: right"]2018-05-19[/TD]
[/TR]
[TR]
[TD="align: right"]2018-05-19[/TD]
[/TR]
[TR]
[TD="align: right"]2018-05-19[/TD]
[/TR]
[TR]
[TD="align: right"]2018-05-19[/TD]
[/TR]
[TR]
[TD="align: right"]2018-05-19[/TD]
[/TR]
[TR]
[TD="align: right"]2018-05-19[/TD]
[/TR]
[TR]
[TD="align: right"]2018-05-19[/TD]
[/TR]
[TR]
[TD="align: right"]2018-05-19[/TD]
[/TR]
[TR]
[TD="align: right"]2018-05-19[/TD]
[/TR]
[TR]
[TD="align: right"]2018-05-18[/TD]
[/TR]
[TR]
[TD="align: right"]2018-05-18[/TD]
[/TR]
[TR]
[TD="align: right"]2018-05-18[/TD]
[/TR]
[TR]
[TD="align: right"]2018-05-18[/TD]
[/TR]
[TR]
[TD="align: right"]2018-05-18[/TD]
[/TR]
[TR]
[TD="align: right"]2018-05-18[/TD]
[/TR]
[TR]
[TD="align: right"]2018-05-18[/TD]
[/TR]
[TR]
[TD="align: right"]2018-05-18[/TD]
[/TR]
[TR]
[TD="align: right"]2018-05-18[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]

 

[WaterGypsy]

Have you tried a pivot table?
Or you could put a COUNTIFS formula in the adjacent column