Thread: Count, number of entries of a particular month.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PCLIVE PCLIVE is offline
external usenet poster
  
Posts: 1,311
Default Count, number of entries of a particular month.
One way:

=SUMPRODUCT(--(MONTH(A1:A100)=4),--(YEAR(A1:A100)=2007))

HTH,
Paul

"Danny" wrote in message
...
Hi,

On Column A, say, rows A1:A100 has different dates. How can I count the
number of rows that are dated for the month of April 2007?

Please help.


Reply With QuoteReply With Quote