Thread: Counting specific dates
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
gooders gooders is offline
external usenet poster
  
Posts: 7
Default Counting specific dates
Sorry further to above I know that I can use the following:

=COUNT(IF(MONTH(A1:A100)=11,1,"")) as an array formula but I want to be able
to differentiate also between years, i.e. November 2009 and November 2010 etc.
Reply With QuoteReply With Quote