How to count DISTINCT countries within a date range?

Quarterly, I am required to show how many DISTINCT countries were reached by our instructors. I need a formula that would count the DISTINCT countries reached between (for example) 1/1/2020 thru 3/31/2020 (for first Quarter reporting). I've attached a snippet from my Smartsheet to show the setup.

I have the formula for counting DISTINCT countries, but I need to add the date range.


Thank you for your help!!!

Kitty Sandel


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!