Calculate Occurrences in a Month

MVZ

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.

Ryan Sides

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.

Ryan Sides

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.

MVZ

Thank you so much @Ryan Sides that worked!

Ryan Sides

You're welcome! Glad to hear it 😄

EmilyCamp

@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?

Ryan Sides

@EmilyCamp

Sure thing! I'd add a year item as well…

=COUNTIFS({Source Range}, IFERROR(MONTH(@cell), 0) = 8, {Source Range}, IFERROR(YEAR(@cell), 0) = 2024)