count the occurance of a particular month in a column of dates

R

Ray Sr

I'm having no luck getting a total count of the number of times a particular
month is present in a date column.

This is what I've been trying to get a count of the number of dates that
fall in the month of July, regardless of the year:

=COUNT(MONTH(I$1:I286),7)

Can anyone help me solve this little problem
 
R

Ray Sr

That worked fine, but I have column headings every 41 rows for printing
purposes which I think screwed things up a bit, so I used that formula to do
sub-totals before each new set of headings and it worked great! Thanks
 

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

Access Count dates within a Month 4
Count occurance of a month in a column of dates? 1
Count, number of entries of a particular month. 4
Counting dates with specific criteria 1
Counting Dates - Not Text 2
count wednesdays within a month 7
Count a specific month in a column 7
use month in cell date to sum all relevant cells 2

Top