ExcelBanter - Count occurance of a month in a column of dates?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Count occurance of a month in a column of dates? (https://www.excelbanter.com/excel-worksheet-functions/156492-count-occurance-month-column-dates.html)

Stormy

Count occurance of a month in a column of dates?

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

Peo Sjoblom

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.

All times are GMT +1. The time now is 07:29 AM.