Thread: Count occurance of a month in a column of dates?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
  
Posts: 3,268
Default Count occurance of a month in a column of dates?
=SUMPRODUCT(--(ISNUMBER(A2:A500)),--(MONTH(A2:A500)=2))

would count February


=SUMPRODUCT(--(ISNUMBER(A2:A500)),--(YEAR(A2:A500)=2007),--(MONTH(A2:A500)=2))

would count February 2007



--
Regards,

Peo Sjoblom





"Stormy" wrote in message
...
In Excel I'm trying to count the number of times a given month occurs in a
column of values of the type date.


Reply With QuoteReply With Quote