Count date occurences within a year

  • Thread starter Thread starter Lou
  • Start date Start date
L

Lou

I have a column containing specific dates on which an event occurred and am
trying to create a formula that counts how many dates fall within a given
year. Any help is appreciated.
 
This formula will count all dates in the range that are in the year 2007:

=SUMPRODUCT(--(YEAR(A1:A10)=2007))
 
You must log in or register to reply here.

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

Excel 2003 - Count dates 3
Count occurance of months 10
counting blank cells within two columns 2
Excel Formula - Count Dates from another Sheet 8
Count specific days in between dates 2
counting cells that fall within a certain date range 9
Normaliziing date and counting # of of occurances 1
Summing the number of incomplete jobs within a date range -sumprod 6

Back
Top