count the number of times a date is shown.

[brianflieck]

i have a list of files with dates associated. i'd like to simply count the number of times each date is being shown.

for example, 1/2/18 is shown below 10 times. I have this for an entire calendar year.

[TABLE="width: 208"]
<colgroup><col></colgroup><tbody>[TR]
[TD="align: right"]1/2/18[/TD]
[/TR]
[TR]
[TD="align: right"]1/2/18[/TD]
[/TR]
[TR]
[TD="align: right"]1/2/18[/TD]
[/TR]
[TR]
[TD="align: right"]1/2/18[/TD]
[/TR]
[TR]
[TD="align: right"]1/2/18[/TD]
[/TR]
[TR]
[TD="align: right"]1/2/18[/TD]
[/TR]
[TR]
[TD="align: right"]1/2/18[/TD]
[/TR]
[TR]
[TD="align: right"]1/2/18[/TD]
[/TR]
[TR]
[TD="align: right"]1/2/18[/TD]
[/TR]
[TR]
[TD="align: right"]1/2/18[/TD]
[/TR]
[TR]
[TD="align: right"]1/3/18[/TD]
[/TR]
[TR]
[TD="align: right"]1/3/18[/TD]
[/TR]
[TR]
[TD="align: right"]1/3/18[/TD]
[/TR]
[TR]
[TD="align: right"]1/3/18[/TD]
[/TR]
[TR]
[TD="align: right"]1/3/18[/TD]
[/TR]
[TR]
[TD="align: right"]1/3/18[/TD]
[/TR]
[TR]
[TD="align: right"]1/3/18[/TD]
[/TR]
[TR]
[TD="align: right"]1/3/18[/TD]
[/TR]
[TR]
[TD="align: right"]1/3/18[/TD]
[/TR]
[TR]
[TD="align: right"]1/3/18[/TD]
[/TR]
[TR]
[TD="align: right"]1/3/18[/TD]
[/TR]
[TR]
[TD="align: right"]1/3/18[/TD]
[/TR]
[TR]
[TD="align: right"]1/3/18[/TD]
[/TR]
[TR]
[TD="align: right"]1/3/18[/TD]
[/TR]
[TR]
[TD="align: right"]1/3/18[/TD]
[/TR]
[TR]
[TD="align: right"]1/3/18[/TD]
[/TR]
[TR]
[TD="align: right"]1/3/18[/TD]
[/TR]
[TR]
[TD="align: right"]1/3/18[/TD]
[/TR]
[TR]
[TD="align: right"]1/3/18[/TD]
[/TR]
[TR]
[TD="align: right"]1/3/18[/TD]
[/TR]
[TR]
[TD="align: right"]1/3/18[/TD]
[/TR]
[TR]
[TD="align: right"]1/3/18[/TD]
[/TR]
[TR]
[TD="align: right"]1/3/18[/TD]
[/TR]
</tbody>[/TABLE]

 

[alansidman]

Employ the countif function. If you have your list in column A and a list of the calendar dates in column E, then in column B

=COUNTIF($A$1:$A$33,E1) and copy down.

If you wish to put the dates in manually then,

=COUNTIF($A$1:$A$33,"1/2/2018")