Count date occurences within a year

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.
 
T

T. Valko

This formula will count all dates in the range that are in the year 2007:

=SUMPRODUCT(--(YEAR(A1:A10)=2007))
 
Top