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

✭✭✭
edited 11/17/23

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?

• ✭✭✭✭✭✭

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

• ✭✭✭✭✭✭

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

• ✭✭✭

It worked! Thank you so much!!

• ✭✭✭✭✭✭

@SOmalley1124 - awesome! Have a great rest of your week!

Peggy

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!