COUNTIFS and Date Range

Lindsay Wilson

Hi

I'm wondering if anyone can help. My formula below works great, but I want to adjust what's included in this count.

For this count I want to filter on current date date from a range in a column (Current Due Date).

e.g. date range 30/04/2019 to 30/04/2020

=COUNTIFS({BC KPI}, $Measure2, {Business Unit}, [Business Unit]2, {Project Status}, OR(@cell = "Shipped", @cell = "In Progress"))

I've been looking at the formula function help wiki for date functions : https://help.smartsheet.com/functions but hit a brick wall. Any recommendations on what function I should use?

Thanks.

Lindsay

Paul Newcome

Try this...

=COUNTIFS({BC KPI}, $Measure2, {Business Unit}, [Business Unit]2, {Project Status}, OR(@cell = "Shipped", @cell = "In Progress"), {Date Range}, AND(@cell >= DATE(2019, 04, 30), @cell <= DATE(2020, 04, 30)))

Lindsay Wilson

@Paul Newcome This worked thank you!

Lindsay

Paul Newcome

Try this...

=COUNTIFS({BC KPI}, $Measure2, {Business Unit}, [Business Unit]2, {Project Status}, OR(@cell = "Shipped", @cell = "In Progress"), {Date Range}, AND(@cell >= DATE(2019, 04, 30), @cell <= DATE(2020, 04, 30)))

Lindsay Wilson

@Paul Newcome This worked thank you!

Lindsay

Paul Newcome

Happy to help. 👍️