Thread: Counting numbers of date within a spesific month
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default Counting numbers of date within a spesific month
Try

=SUMPRODUCT(--(MONTH(A1:A20)=2),--(YEAR(A1:A20)=2008))

Mike

"Kriss" wrote:

I forgot to mention that I also need to sort them by year. As the list goes
on until 2013. What should I add to the formula to manage this?
Reply With QuoteReply With Quote