Count Dates but by week if possible - Weekly trends
I've tried a count if, count and countif function.
Trying to Count how many in a date range. Sunday through Saturday as my base week. How many times in week 5/9 to 5/14 was a request put in.
Would I need to count each date? Like count if date @row 2021,5,9? In the screenshot above the answer would be 4. But I would need a separate formula for all 52 weeks in a year? Formula for a daily count?
Just trying to show weekly trends....
Help Article Resources
Check out the Formula Handbook template!