Counting occurrences within each month

**Fatosi** · 09-14-2012, 12:22 PM

Hi all,

I have a spreadsheet where I would like to count occurrences within a month, no other condition required just to count the dates that fall within a month for all the months. Two columns, one Date Hired, the other Date Resigned, now all I want is to know how many were hired within, for example, the month of July 2011 and how many resigned in that very same month.

What would be the formula to count every date that fell in July 11 for both those Hired and those that resigned.

Se the image below.

Thank you all you guys for the great work and help you offer in this forum.

Sample.jpg

**Teepet** · 09-14-2012, 04:26 PM

I actually joined with the intention of asking a similar question. I've found the month() function which in an if statement works just fine
=if(month(datarange)=1, 1, 0)
but count doesn't have that nice logical statment set up so it's hard to deal with.
=countif(month(datarange), "=1") doesn't work :P

Counting occurrences within each month

LinkBack

Thread Tools

Rate This Thread

Display

Counting occurrences within each month

Re: Counting occurrences within each month

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions