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
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!