count how many times a date appears
 

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

count how many times a date appears
 

For inspection dates, next to E1:

=COUNTIF(C:C,E1)

For total occurrences (inspection and reinspection):

=COUNTIF(C:D,E1)

HTH
Kostis Vezerides

On Oct 12, 5:11 pm, fyrefox wrote:
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