count how many times a date appears

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
For inspection dates, next to E1:

=COUNTIF(C:C,E1)

For total occurrences (inspection and reinspection):

=COUNTIF(C:D,E1)

HTH
Kostis Vezerides
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing data from Excel worksheet into Excel template 2
Calculate the number of days from a specific date 5
Date 1
Date Formula 1
DAYS360 where Start Date is Static and End Date is Latter of Two Dates 1
How to Count Dates in 2 Lists 2
Help wit a formula 1
Counting checkboxes between two dates 2

Back
Top