count how many times a date appears

F

fyrefox

I have an excel worksheet with inspection dates in column c and reinspection
dates in column d. In columnn e I have the dates of the year. I want to
determine how many times each date appears in comumn c and d.
my final result will be a simple chart from this data.

Thanks in advance,
Fyrefox
 
V

vezerid

For inspection dates, next to E1:

=COUNTIF(C:C,E1)

For total occurrences (inspection and reinspection):

=COUNTIF(C:D,E1)

HTH
Kostis Vezerides
 
Top