Hello Awesome People,
1. I want excel to determine number of items that are added to the table a week before at the start of every week.
2. Similarly, I want excel to determine number of items that are closed a week before at the start of every week.
3. The two results should help me to navigate the added/closed items ID using a filter.
4. Help me with proper naming convention as I am creating this for a dashboard.
| Id | Task | Date Entered | Resolution date | Statuses |
| T1 | Task A | oct 1-2022 | | Open |
| F2 | Task C | oct 17-2022 | | Closed |
| C33 | Task c314 | oct 26-2022 | | Open |
| F4 | task Z89 | oct 26-2022 | | Closed |
| J96 | Task 88 | Sept 1-2022 | | open |
