Count occurance of a month in a column of dates?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In Excel I'm trying to count the number of times a given month occurs in a
column of values of the type date.
 
=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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

EXCEL COUNTING HELP 3
Counting number of times name occurs between two dates 2
count the occurance of a particular month in a column of dates 2
count the occurrences of a month in a date&time cell 6
use month in cell date to sum all relevant cells 2
Counting Dates - Not Text 2
Count Unique Values in 1 Column based on Date Range in another Column 28
counting multiple dates in a range 1

Back
Top