AVG(Collect) Formula help with date range

sonam.bang

Is there a way I can give a date range in the formula below so that it averages between dates 8/21/19 - 10/29/19

=AVG(COLLECT({Nexus Dependencies Range 5}, {Nexus Dependencies Range 1}, "The Scrum Lords", {Nexus Dependencies Range 3}, DATE(2019, 10, 29)))

Paul Newcome

I am assuming Range 3 is the date range you want to compare against. If that is the case, try this...

 

=AVG(COLLECT({Nexus Dependencies Range 5}, {Nexus Dependencies Range 1}, "The Scrum Lords", {Nexus Dependencies Range 3}, AND(@cell >= DATE(2019, 8, 21), @cell <= DATE(2019, 10, 29))))

sonam.bang

It Worked..Thanks

Paul Newcome

Happy to help!