Current Year Month in a count formula

Jim Bob Green

I'm having problems finding the right syntax to count the number of records for the current year month. My sheet may have records from several past years but I just need to count the number of records by month for JUST for the current year - even if I must update the formula each January - that's ok.

My basic formula for counting the months using a cross sheet formula works like a champ. Unfortunately, I'm stuck trying to find how to enhance the formula for just the months in the current year. Any pointers would be greatly appreciated. Here is my current basic formula for counting the months:

=COUNTIF({ProposalsSubmissionDate}, IFERROR(MONTH(@cell), 0) = 1)

This version is of course only counting January. I have a sheet that I'm using just for the counters so each row will represent the current year month - January thru December.

Heather Duff

Hi Jim Bob,

Try this:

=COUNTIFS({ProposalsSubmissionDate}, IFERROR(MONTH(@cell), 0) = 1, {ProposalsSubmissionDate}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()))

Heather Duff

Well, thank you! Glad it worked. :)

Heather Duff

Hi Jim Bob,

Try this:

=COUNTIFS({ProposalsSubmissionDate}, IFERROR(MONTH(@cell), 0) = 1, {ProposalsSubmissionDate}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()))

Jim Bob Green

Heather D is a freakin' ROCK STAR!! Yes, that is beautiful.

Heather Duff

Well, thank you! Glad it worked. :)