Entries per year

  • Thread starter Thread starter onebodaciousbabe03
  • Start date Start date
O

onebodaciousbabe03

I have a spreadsheet with a column for date. I would like to use a function
that will tell me how many entries there are per year. I have the dates
entered as 7/29/2009, etc. I can't seem to get it right. Any ideas? Thanks
in advance!
 
Hi,

Suppose your dates are in column A then enter the year in G1, say 2009 and
then use

=SUMPRODUCT(--(YEAR(A1:A28)=G1))
 
Back
Top