Hi ,
I would want to count the no of days that appear in each week of a month
Eg: 1st of feb has data from 30-Jan to 5-feb which means 5 days of feb in week 1
like below:
| Year |
Month |
Week |
Days per week |
Days per Month |
| 2022 |
1 |
1 |
1 |
31 |
| 2022 |
1 |
2 |
7 |
31 |
| 2022 |
1 |
3 |
7 |
31 |
| 2022 |
1 |
4 |
7 |
31 |
| 2022 |
1 |
5 |
7 |
31 |
| 2022 |
1 |
6 |
2 |
28 |
| 2022 |
2 |
6 |
5 |
28 |
| 2022 |
2 |
7 |
7 |
28 |
| 2022 |
2 |
8 |
7 |
28 |
| 2022 |
2 |
9 |
7 |
28 |
| 2022 |
2 |
10 |
2 |
28 |
I have crude way of developing it, but would like to know if there is a cleaner and smarter way to do it
