need help to determine items added/closed a week before till the current date. Navigate them too.

Occasional Visitor

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.

 

 

IdTaskDate EnteredResolution dateStatuses
T1Task Aoct 1-2022 Open
F2Task Coct 17-2022 Closed
C33Task c314oct 26-2022 Open
F4task Z89oct 26-2022 Closed
J96Task 88Sept 1-2022 open
0 Replies