Create metrics using a Date Range
Hello - I am trying to build metrics that show how many projects are created with specific quarters based off a Date completed column. Currently using this formula but it is not working:
=COUNTIFS({Project List Range 1}, "Closed", {Project List Range 3}, >=DATE(2020, 1, 1) <= DATE(2020, 3, 31))
Any helpful tips would be appreciated. The 1st argument is pulling data from a status column. When the project moves to closed, want to calculate how many projects closed within quarter 1, quarter 2, etc.
Thanks in advance
Best Answer
-
Try this slight adjustment...
=COUNTIFS({Project List Range 1}, "Closed", {Project List Range 3}, AND(@cell >= DATE(2020, 1, 1), @cell <= DATE(2020, 3, 31)))
Answers
-
Try this slight adjustment...
=COUNTIFS({Project List Range 1}, "Closed", {Project List Range 3}, AND(@cell >= DATE(2020, 1, 1), @cell <= DATE(2020, 3, 31)))
-
Thanks Paul that did the trick. Really appreciate the assistance.
Help Article Resources
Categories
Check out the Formula Handbook template!