Date Formula

Chris Hallo

Good morning! I need help with a date formula (highlighted). It's counting but not the total where the start date is in the next 7 days. You can see the sheet summary fields as I want to use the "7 days out" as a metric on a dashboard. If I replace the range1 to a unique column, the formula returns zero...I'm confused. Help, please!

Paul Newcome

Try adding a second range/criteria set where the range is the [Start Date] collumn again, and the criteria is greater than or equal to today.

[Start Date]:[Start Date], @cell >= TODAY()

Paul Newcome

Remove the second [Start Date]:[Start Date.

Chris Hallo

Hi Paul! It's counting all the rows in the sheet and not returning just those where the start date is within the next seven days...

Paul Newcome

Try adding a second range/criteria set where the range is the [Start Date] collumn again, and the criteria is greater than or equal to today.

[Start Date]:[Start Date], @cell >= TODAY()