COUNTIFS with multiple range and same criteria

Options
jcasorla1
jcasorla1 ✭✭
edited 08/24/23 in Formulas and Functions

Hello Everyone,

I need help, to figure out how to do a COUNTIFS for the following:

I have 3 separate date columns (WorkDate, OutreachDate and ContactedDate). I want to do a count if any of the dates fall under the same calendar month. So it will be like an OR range and one criteria. Please advise. Thank you.

Jason

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!