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))
 
Back
Top