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 😄