COUNTIF between dates
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))
Comments
-
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
-
=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.
-
Thank you TJ and Paul - the change to COUNTIFS worked perfectly!
Thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!