What is wrong with this formula?
I'm trying to count all consultation meetings between 1/1/19-12/31/21. This is the formula I came up with and it does not work.
=COUNTIFS([RPP Consultation Meeting?]:[RPP Consultation Meeting?], HAS(@cell, "TRUE"), [Intake Date]:[Intake Date] >= DATE(2019, 1, 1), [Intake Date]:[Intake Date] <= DATE(2021, 12, 31))
Any help would be very much appreciated!
Help Article Resources
Check out the Formula Handbook template!