COUNTIF between dates

edited 12/09/19 in Formulas and Functions


I have read a few posts about calculating values between dates but I'm still having an issue. I am trying to calculate a numeric value (basically a go-live date for 3 different project types) within a specific date rage. I want to calculate how may clients are brought live between April 1, 2018 and June 30, 2018. The string I have is below but its obviously not working. Any thoughts? 

=COUNTIF({Enterprise Client Tracker Range 1}, =Status1, {Enterprise Client Tracker Range 4} >= DATE(2018, 4, 1), {Enterprise Client Tracker Range 4} < DATE(2018, 6, 30))



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!