How to categorize data in weeks?

Hi

Let me clarify.

Column U to show count of tasks closed in a particular week with below conditions:

where,

Column G in sheet "Closed" = TSCO REQ

Column N = Date to be considered

For example,

1st week of Jan had date 01.01.2023 and no task were closed on that day. Hence cell U52 = 0

2nd week of Jan had dates 2 to 08.01.2023 in which 28 tasks were closed. hence cell U53 = 28

The data shall so on be populated on weekly basis.


The same weekly data for column V for below conditions in sheet "Closed"

where,

Column G = TSCO REQ or TSCO SKP

Column I = Repeat Data Prov. Task: See Long Text

Column N = Date to be considered

For example,

Tasks with above conditions exist on 02, 21 and 28 Feb. Hence, cells V58 = 1, V61 = 1, V62 = 1


Coming to Column T, Jan had 6 weeks. So for January in Column S, column T should have 6 rows as Week 1 up to Week 6 without any additional rows in between.

Hope i was able to explain