Counting number of occurrences

G

Guest

I have a column with several hundred entries in date format m/d/yyyy. Is
there a formula to count the number of occurrences for each unique value of
yyyy? In other words how many of the dates fall within 2003, 2004, 2005,
etc. Thanks.
 

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

Counting Occurrence of a Value within Cells 1
Counting number of occurrences. 1
Counting Dates - Not Text 2
Counting number of rows between date range and meeting 2 string criteria 11
Search for Condition, Text based, Date Range, Occurrences 1
Counting occurrences on a particular date 6
Extracting List of Occurrences 7
SUMIF with 2 creteria one Name one DAte 1

Top