Counting between dates greater than or less than a date

BFuller ✭✭✭
edited 10/06/22 in Formulas and Functions


I have the following formula coming back as unparseable. I am trying to calculate how many OOB Ambients in each month of the year. I normally have a date sheet that I reference, but I'm thinking using the date function might be cleaner. Can someone look at the formula below and identify my mistake?

=COUNTIFS({OS Visit Report Type}, "OOB", {OS Equipment Category}, "Ambient", {OS Activity Date}, >=(DATE(2022, 01, 01), {OS Activity Date}, <=DATE(2022, 01, 31)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!