Calculate Occurrences in a Month
I'm trying to calculate the number of tour requests I receive in a month. Each tour is listed as an individual line item with date format MM/DD/YY. I tried the formula =COUNTIF({Source Range}, MONTH(TODAY())) but I'm getting "UNPARSABLE". I want to be able to show on a dashboard how many requests we received for the current month only.
Best Answer
-
Hi @MVZ give this one a try... It will count any dates that have the same month as today's month. Be sure your Source Range date column is an actual date type column.
=COUNTIFS({Source Range}, IFERROR(MONTH(@cell), 0) = MONTH(TODAY()))
Let me know if that works for you.
Answers
-
Hi @MVZ give this one a try... It will count any dates that have the same month as today's month. Be sure your Source Range date column is an actual date type column.
=COUNTIFS({Source Range}, IFERROR(MONTH(@cell), 0) = MONTH(TODAY()))
Let me know if that works for you.
-
Thank you so much @Ryan Sides that worked!
-
@Ryan Sides Your formula worked great for current month's count as the OP requested. I am wondering can I add something to the formula to specifically pull counts from a month of the year to track historical data? i.e. all requests for August 2024?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 432 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 76 Community Job Board
- 504 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!