Create metrics using a Date Range

Shane Cornwell

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

Paul Newcome

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

Paul Newcome

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

Shane Cornwell

Thanks Paul that did the trick. Really appreciate the assistance.

Paul Newcome

Happy to help! 👍️