Date Formula
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!
Best Answer
-
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()
Answers
-
-
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...
-
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()
Help Article Resources
Categories
Check out the Formula Handbook template!