Pull unique dates, add a count, and group them by weeks
I have a project sheet with a series of dates of when tasks were completed. I need to build a dashboard to display how many tasks were completed per week. For example Nov 2 - 3 tasks, Nov 8 - 10 tasks, Nov 15 - 5 tasks
Is there a way to pull into a metric sheet the unique dates and then group them by weeks?
Help Article Resources
Check out the Formula Handbook template!