Formula to calculate number of tour requests in the current month and year, not over multiple years

Options
SOmalley1124
SOmalley1124 ✭✭✭
edited 11/17/23 in Formulas and Functions

I'm trying to calculate the number of tour requests I receive in a month. This sheet has dates that go back two years. Each tour is listed as an individual line item with date format MM/DD/YY. I tried the formula =COUNTIFS({Tour Request Range 7}, IFERROR(MONTH(@cell), 0) = MONTH(TODAY())) but it is showing the number of tours for the month of November in 2022 and 2023 combined, not just in 2023. Is there a different formula to only show the number of tours this current month only?

Best Answer

  • Peggy Parchert
    Peggy Parchert ✭✭✭✭✭✭
    Answer ✓
    Options

    Hello @SOmalley1124

    Hope you are well. Try this:

    =COUNTIF({Tour Request Date}, AND(IFERROR(MONTH(@cell), 0) = MONTH(TODAY()), IFERROR(YEAR(@cell), 0) = YEAR(TODAY())))

    Where:

    {Tour Request Date} is the column that lists the dates of each individual tour.

    Let me know if this helps.

    Peggy

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!