CountIf with Date ranges

Trying to write a formula that counts the number of instances based on a date range. I can get the instances to populate in a formula by themselves but I cannot get the date range to work?

This is weird as the formula works in another sheet for another scenario.

=COUNTIFS({CURRENT CHECKOUT SCENARIO Range 1}, [Primary Column]@row, {CURRENT CHECKOUT SCENARIO Range 2}, AND(@cell >= DATE(1965, 1, 30), @cell <= DATE(2021, 4, 30)))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!