Google Sheets: WEEKNUM, WEEKDAY, FILTER, VLOOKUP, TODAY
One really helpful metric to check performance is to compare the current weeks worth of data against the previous weeks. I have had need of this in all sorts of projects such as:
- Comparing sales performance from previous weeks to current.
- Comparing hours worked on different tasks from week to week.
- Compare the assessment balance between weekly tests.
- Compare attendance numbers.
The problem is you often only receive data in to form of a date, like 1 Nov 2020. We will go through one possible solution to this problem in this tutorial.
We’ll run through an example together that you should be able to quickly adapt to your own project.
Let’s get cracking!