ExcelBanter - Counting occurrences of specific month

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Counting occurrences of specific month (https://www.excelbanter.com/excel-discussion-misc-queries/169559-counting-occurrences-specific-month.html)

bpoland58

Counting occurrences of specific month

I have a column oof dates and times (ex. 11/19/2007 1:50:00 PM). Is there any
way to count the number of times there is an entry for the month only. In
this example the month of Nov.

Peo Sjoblom

Counting occurrences of specific month

=SUMPRODUCT(--(ISNUMBER(A1:A20)),--(MONTH(A1:A20)=11))

if you get a value error then they are text and not numerical Excel dates

--

Regards,

Peo Sjoblom

"bpoland58" wrote in message
...
I have a column oof dates and times (ex. 11/19/2007 1:50:00 PM). Is there
any
way to count the number of times there is an entry for the month only. In
this example the month of Nov.

bpoland58

Counting occurrences of specific month

Thanks That does it.

"Peo Sjoblom" wrote:

=SUMPRODUCT(--(ISNUMBER(A1:A20)),--(MONTH(A1:A20)=11))

if you get a value error then they are text and not numerical Excel dates

--

Regards,

Peo Sjoblom

"bpoland58" wrote in message
...
I have a column oof dates and times (ex. 11/19/2007 1:50:00 PM). Is there
any
way to count the number of times there is an entry for the month only. In
this example the month of Nov.

All times are GMT +1. The time now is 11:22 PM.