COUNTIF between dates

Kirkk

Hello

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))

TJ (Tracie) Peters

Hi Kirkk,

I believe you have to use the COUNTIFS function since you are using multiple criteria. Here's the example I worked out: 

=COUNTIFS(Status:Status, "Complete", GoLive:GoLive, >=DATE(2018, 4, 1), GoLive:GoLive, <=DATE(2018, 6, 1))

I hope that helps. Keep us updated!

Best regards,

TJ

 

Paul Newcome

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

 

This should work for you.

Kirkk

Thank you TJ and Paul - the change to COUNTIFS worked perfectly!

Thank you!