Current Year Month in a count formula
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.
Best Answers
-
Hi Jim Bob,
Try this:
=COUNTIFS({ProposalsSubmissionDate}, IFERROR(MONTH(@cell), 0) = 1, {ProposalsSubmissionDate}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()))
-
Well, thank you! Glad it worked. :)
Answers
-
Hi Jim Bob,
Try this:
=COUNTIFS({ProposalsSubmissionDate}, IFERROR(MONTH(@cell), 0) = 1, {ProposalsSubmissionDate}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()))
-
Heather D is a freakin' ROCK STAR!! Yes, that is beautiful.
-
Well, thank you! Glad it worked. :)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!