Postgres 15

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();


version


PostgreSQL 15.0 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-10), 64-bit



SELECT 1


-- setup
create table non_standard_calendar( 
             nsw_id              integer  generated always as identity
                                          primary key
           , gegorian_date       date     not null 
                                          unique
           , year                smallint
           , week_of_year        smallint
           , day_of_year         smallint
           , doy_of_week         smallint
           );

select * 
  from non_standard_calendar; 

CREATE TABLE




nsw_id
gegorian_date
year
week_of_year
day_of_year
doy_of_week



SELECT 0


-- procedure to create calendar
create or replace procedure generate_non_standard_calendar(yr_in integer)
       language sql
     as $$
        with recursive ns_cal (gdate     -- gegorian date
                              ,nsc_yr    -- yr_in
                              ,nsc_woy   -- non_standard week of year
                              ,nsc_doy   -- non_standard day of year
                              ,nsc_dow   -- non-standard day of week
                              ) as
                       ( select make_date(yr_in,01,01)
                              , yr_in 
                              , 1
                              , 1
                              , 1
                         union all 
                         select gdate + 1                         -- gdate
                              , nsc_yr                            -- nsc_yr 
                              , case when to_char(gdate, 'dy') = 'fri'
                                     then nsc_woy + 1
                                     else nsc_woy 
                                end 
                              , (nsc_doy + 1)                     -- nsc_doy
                              , case when to_char(gdate, 'dy') = 'fri'
                                     then 1
                                     else nsc_dow+1
                                end                  -- nsc_dow
                           from ns_cal 
                          where extract(year from gdate + 1) = yr_in
                      )
         insert into  non_standard_calendar( gegorian_date 
                                           , year                 
                                           , week_of_year         
                                           , day_of_year       
                                           , doy_of_week 
                                           ) 
                select gdate     -- gegorian date
                     , nsc_yr    -- yr_in
                     , nsc_woy   -- non_standard week of year
                     , nsc_doy   -- non_standard day of year
                     , nsc_dow   -- non-standard day of week
                  from ns_cal;
$$;

CREATE PROCEDURE


-- define 2023 calander 
do $$
begin
   call generate_non_standard_calendar(2023);
end;
$$;

DO


select * 
  from non_standard_calendar;


nsw_id
gegorian_date
year
week_of_year
day_of_year
doy_of_week


1
2023-01-01
2023
1
1
1

2
2023-01-02
2023
1
2
2

3
2023-01-03
2023
1
3
3

4
2023-01-04
2023
1
4
4

5
2023-01-05
2023
1
5
5

6
2023-01-06
2023
1
6
6

7
2023-01-07
2023
2
7
1

8
2023-01-08
2023
2
8
2

9
2023-01-09
2023
2
9
3

10
2023-01-10
2023
2
10
4

11
2023-01-11
2023
2
11
5

12
2023-01-12
2023
2
12
6

13
2023-01-13
2023
2
13
7

14
2023-01-14
2023
3
14
1

15
2023-01-15
2023
3
15
2

16
2023-01-16
2023
3
16
3

17
2023-01-17
2023
3
17
4

18
2023-01-18
2023
3
18
5

19
2023-01-19
2023
3
19
6

20
2023-01-20
2023
3
20
7

21
2023-01-21
2023
4
21
1

22
2023-01-22
2023
4
22
2

23
2023-01-23
2023
4
23
3

24
2023-01-24
2023
4
24
4

25
2023-01-25
2023
4
25
5

26
2023-01-26
2023
4
26
6

27
2023-01-27
2023
4
27
7

28
2023-01-28
2023
5
28
1

29
2023-01-29
2023
5
29
2

30
2023-01-30
2023
5
30
3

31
2023-01-31
2023
5
31
4

32
2023-02-01
2023
5
32
5

33
2023-02-02
2023
5
33
6

34
2023-02-03
2023
5
34
7

35
2023-02-04
2023
6
35
1

36
2023-02-05
2023
6
36
2

37
2023-02-06
2023
6
37
3

38
2023-02-07
2023
6
38
4

39
2023-02-08
2023
6
39
5

40
2023-02-09
2023
6
40
6

41
2023-02-10
2023
6
41
7

42
2023-02-11
2023
7
42
1

43
2023-02-12
2023
7
43
2

44
2023-02-13
2023
7
44
3

45
2023-02-14
2023
7
45
4

46
2023-02-15
2023
7
46
5

47
2023-02-16
2023
7
47
6

48
2023-02-17
2023
7
48
7

49
2023-02-18
2023
8
49
1

50
2023-02-19
2023
8
50
2

51
2023-02-20
2023
8
51
3

52
2023-02-21
2023
8
52
4

53
2023-02-22
2023
8
53
5

54
2023-02-23
2023
8
54
6

55
2023-02-24
2023
8
55
7

56
2023-02-25
2023
9
56
1

57
2023-02-26
2023
9
57
2

58
2023-02-27
2023
9
58
3

59
2023-02-28
2023
9
59
4

60
2023-03-01
2023
9
60
5

61
2023-03-02
2023
9
61
6

62
2023-03-03
2023
9
62
7

63
2023-03-04
2023
10
63
1

64
2023-03-05
2023
10
64
2

65
2023-03-06
2023
10
65
3

66
2023-03-07
2023
10
66
4

67
2023-03-08
2023
10
67
5

68
2023-03-09
2023
10
68
6

69
2023-03-10
2023
10
69
7

70
2023-03-11
2023
11
70
1

71
2023-03-12
2023
11
71
2

72
2023-03-13
2023
11
72
3

73
2023-03-14
2023
11
73
4

74
2023-03-15
2023
11
74
5

75
2023-03-16
2023
11
75
6

76
2023-03-17
2023
11
76
7

77
2023-03-18
2023
12
77
1

78
2023-03-19
2023
12
78
2

79
2023-03-20
2023
12
79
3

80
2023-03-21
2023
12
80
4

81
2023-03-22
2023
12
81
5

82
2023-03-23
2023
12
82
6

83
2023-03-24
2023
12
83
7

84
2023-03-25
2023
13
84
1

85
2023-03-26
2023
13
85
2

86
2023-03-27
2023
13
86
3

87
2023-03-28
2023
13
87
4

88
2023-03-29
2023
13
88
5

89
2023-03-30
2023
13
89
6

90
2023-03-31
2023
13
90
7

91
2023-04-01
2023
14
91
1

92
2023-04-02
2023
14
92
2

93
2023-04-03
2023
14
93
3

94
2023-04-04
2023
14
94
4

95
2023-04-05
2023
14
95
5

96
2023-04-06
2023
14
96
6

97
2023-04-07
2023
14
97
7

98
2023-04-08
2023
15
98
1

99
2023-04-09
2023
15
99
2

100
2023-04-10
2023
15
100
3

101
2023-04-11
2023
15
101
4

102
2023-04-12
2023
15
102
5

103
2023-04-13
2023
15
103
6

104
2023-04-14
2023
15
104
7

105
2023-04-15
2023
16
105
1

106
2023-04-16
2023
16
106
2

107
2023-04-17
2023
16
107
3

108
2023-04-18
2023
16
108
4

109
2023-04-19
2023
16
109
5

110
2023-04-20
2023
16
110
6

111
2023-04-21
2023
16
111
7

112
2023-04-22
2023
17
112
1

113
2023-04-23
2023
17
113
2

114
2023-04-24
2023
17
114
3

115
2023-04-25
2023
17
115
4

116
2023-04-26
2023
17
116
5

117
2023-04-27
2023
17
117
6

118
2023-04-28
2023
17
118
7

119
2023-04-29
2023
18
119
1

120
2023-04-30
2023
18
120
2

121
2023-05-01
2023
18
121
3

122
2023-05-02
2023
18
122
4

123
2023-05-03
2023
18
123
5

124
2023-05-04
2023
18
124
6

125
2023-05-05
2023
18
125
7

126
2023-05-06
2023
19
126
1

127
2023-05-07
2023
19
127
2

128
2023-05-08
2023
19
128
3

129
2023-05-09
2023
19
129
4

130
2023-05-10
2023
19
130
5

131
2023-05-11
2023
19
131
6

132
2023-05-12
2023
19
132
7

133
2023-05-13
2023
20
133
1

134
2023-05-14
2023
20
134
2

135
2023-05-15
2023
20
135
3

136
2023-05-16
2023
20
136
4

137
2023-05-17
2023
20
137
5

138
2023-05-18
2023
20
138
6

139
2023-05-19
2023
20
139
7

140
2023-05-20
2023
21
140
1

141
2023-05-21
2023
21
141
2

142
2023-05-22
2023
21
142
3

143
2023-05-23
2023
21
143
4

144
2023-05-24
2023
21
144
5

145
2023-05-25
2023
21
145
6

146
2023-05-26
2023
21
146
7

147
2023-05-27
2023
22
147
1

148
2023-05-28
2023
22
148
2

149
2023-05-29
2023
22
149
3

150
2023-05-30
2023
22
150
4

151
2023-05-31
2023
22
151
5

152
2023-06-01
2023
22
152
6

153
2023-06-02
2023
22
153
7

154
2023-06-03
2023
23
154
1

155
2023-06-04
2023
23
155
2

156
2023-06-05
2023
23
156
3

157
2023-06-06
2023
23
157
4

158
2023-06-07
2023
23
158
5

159
2023-06-08
2023
23
159
6

160
2023-06-09
2023
23
160
7

161
2023-06-10
2023
24
161
1

162
2023-06-11
2023
24
162
2

163
2023-06-12
2023
24
163
3

164
2023-06-13
2023
24
164
4

165
2023-06-14
2023
24
165
5

166
2023-06-15
2023
24
166
6

167
2023-06-16
2023
24
167
7

168
2023-06-17
2023
25
168
1

169
2023-06-18
2023
25
169
2

170
2023-06-19
2023
25
170
3

171
2023-06-20
2023
25
171
4

172
2023-06-21
2023
25
172
5

173
2023-06-22
2023
25
173
6

174
2023-06-23
2023
25
174
7

175
2023-06-24
2023
26
175
1

176
2023-06-25
2023
26
176
2

177
2023-06-26
2023
26
177
3

178
2023-06-27
2023
26
178
4

179
2023-06-28
2023
26
179
5

180
2023-06-29
2023
26
180
6

181
2023-06-30
2023
26
181
7

182
2023-07-01
2023
27
182
1

183
2023-07-02
2023
27
183
2

184
2023-07-03
2023
27
184
3

185
2023-07-04
2023
27
185
4

186
2023-07-05
2023
27
186
5

187
2023-07-06
2023
27
187
6

188
2023-07-07
2023
27
188
7

189
2023-07-08
2023
28
189
1

190
2023-07-09
2023
28
190
2

191
2023-07-10
2023
28
191
3

192
2023-07-11
2023
28
192
4

193
2023-07-12
2023
28
193
5

194
2023-07-13
2023
28
194
6

195
2023-07-14
2023
28
195
7

196
2023-07-15
2023
29
196
1

197
2023-07-16
2023
29
197
2

198
2023-07-17
2023
29
198
3

199
2023-07-18
2023
29
199
4

200
2023-07-19
2023
29
200
5

201
2023-07-20
2023
29
201
6

202
2023-07-21
2023
29
202
7

203
2023-07-22
2023
30
203
1

204
2023-07-23
2023
30
204
2

205
2023-07-24
2023
30
205
3

206
2023-07-25
2023
30
206
4

207
2023-07-26
2023
30
207
5

208
2023-07-27
2023
30
208
6

209
2023-07-28
2023
30
209
7

210
2023-07-29
2023
31
210
1

211
2023-07-30
2023
31
211
2

212
2023-07-31
2023
31
212
3

213
2023-08-01
2023
31
213
4

214
2023-08-02
2023
31
214
5

215
2023-08-03
2023
31
215
6

216
2023-08-04
2023
31
216
7

217
2023-08-05
2023
32
217
1

218
2023-08-06
2023
32
218
2

219
2023-08-07
2023
32
219
3

220
2023-08-08
2023
32
220
4

221
2023-08-09
2023
32
221
5

222
2023-08-10
2023
32
222
6

223
2023-08-11
2023
32
223
7

224
2023-08-12
2023
33
224
1

225
2023-08-13
2023
33
225
2

226
2023-08-14
2023
33
226
3

227
2023-08-15
2023
33
227
4

228
2023-08-16
2023
33
228
5

229
2023-08-17
2023
33
229
6

230
2023-08-18
2023
33
230
7

231
2023-08-19
2023
34
231
1

232
2023-08-20
2023
34
232
2

233
2023-08-21
2023
34
233
3

234
2023-08-22
2023
34
234
4

235
2023-08-23
2023
34
235
5

236
2023-08-24
2023
34
236
6

237
2023-08-25
2023
34
237
7

238
2023-08-26
2023
35
238
1

239
2023-08-27
2023
35
239
2

240
2023-08-28
2023
35
240
3

241
2023-08-29
2023
35
241
4

242
2023-08-30
2023
35
242
5

243
2023-08-31
2023
35
243
6

244
2023-09-01
2023
35
244
7

245
2023-09-02
2023
36
245
1

246
2023-09-03
2023
36
246
2

247
2023-09-04
2023
36
247
3

248
2023-09-05
2023
36
248
4

249
2023-09-06
2023
36
249
5

250
2023-09-07
2023
36
250
6

251
2023-09-08
2023
36
251
7

252
2023-09-09
2023
37
252
1

253
2023-09-10
2023
37
253
2

254
2023-09-11
2023
37
254
3

255
2023-09-12
2023
37
255
4

256
2023-09-13
2023
37
256
5

257
2023-09-14
2023
37
257
6

258
2023-09-15
2023
37
258
7

259
2023-09-16
2023
38
259
1

260
2023-09-17
2023
38
260
2

261
2023-09-18
2023
38
261
3

262
2023-09-19
2023
38
262
4

263
2023-09-20
2023
38
263
5

264
2023-09-21
2023
38
264
6

265
2023-09-22
2023
38
265
7

266
2023-09-23
2023
39
266
1

267
2023-09-24
2023
39
267
2

268
2023-09-25
2023
39
268
3

269
2023-09-26
2023
39
269
4

270
2023-09-27
2023
39
270
5

271
2023-09-28
2023
39
271
6

272
2023-09-29
2023
39
272
7

273
2023-09-30
2023
40
273
1

274
2023-10-01
2023
40
274
2

275
2023-10-02
2023
40
275
3

276
2023-10-03
2023
40
276
4

277
2023-10-04
2023
40
277
5

278
2023-10-05
2023
40
278
6

279
2023-10-06
2023
40
279
7

280
2023-10-07
2023
41
280
1

281
2023-10-08
2023
41
281
2

282
2023-10-09
2023
41
282
3

283
2023-10-10
2023
41
283
4

284
2023-10-11
2023
41
284
5

285
2023-10-12
2023
41
285
6

286
2023-10-13
2023
41
286
7

287
2023-10-14
2023
42
287
1

288
2023-10-15
2023
42
288
2

289
2023-10-16
2023
42
289
3

290
2023-10-17
2023
42
290
4

291
2023-10-18
2023
42
291
5

292
2023-10-19
2023
42
292
6

293
2023-10-20
2023
42
293
7

294
2023-10-21
2023
43
294
1

295
2023-10-22
2023
43
295
2

296
2023-10-23
2023
43
296
3

297
2023-10-24
2023
43
297
4

298
2023-10-25
2023
43
298
5

299
2023-10-26
2023
43
299
6

300
2023-10-27
2023
43
300
7

301
2023-10-28
2023
44
301
1

302
2023-10-29
2023
44
302
2

303
2023-10-30
2023
44
303
3

304
2023-10-31
2023
44
304
4

305
2023-11-01
2023
44
305
5

306
2023-11-02
2023
44
306
6

307
2023-11-03
2023
44
307
7

308
2023-11-04
2023
45
308
1

309
2023-11-05
2023
45
309
2

310
2023-11-06
2023
45
310
3

311
2023-11-07
2023
45
311
4

312
2023-11-08
2023
45
312
5

313
2023-11-09
2023
45
313
6

314
2023-11-10
2023
45
314
7

315
2023-11-11
2023
46
315
1

316
2023-11-12
2023
46
316
2

317
2023-11-13
2023
46
317
3

318
2023-11-14
2023
46
318
4

319
2023-11-15
2023
46
319
5

320
2023-11-16
2023
46
320
6

321
2023-11-17
2023
46
321
7

322
2023-11-18
2023
47
322
1

323
2023-11-19
2023
47
323
2

324
2023-11-20
2023
47
324
3

325
2023-11-21
2023
47
325
4

326
2023-11-22
2023
47
326
5

327
2023-11-23
2023
47
327
6

328
2023-11-24
2023
47
328
7

329
2023-11-25
2023
48
329
1

330
2023-11-26
2023
48
330
2

331
2023-11-27
2023
48
331
3

332
2023-11-28
2023
48
332
4

333
2023-11-29
2023
48
333
5

334
2023-11-30
2023
48
334
6

335
2023-12-01
2023
48
335
7

336
2023-12-02
2023
49
336
1

337
2023-12-03
2023
49
337
2

338
2023-12-04
2023
49
338
3

339
2023-12-05
2023
49
339
4

340
2023-12-06
2023
49
340
5

341
2023-12-07
2023
49
341
6

342
2023-12-08
2023
49
342
7

343
2023-12-09
2023
50
343
1

344
2023-12-10
2023
50
344
2

345
2023-12-11
2023
50
345
3

346
2023-12-12
2023
50
346
4

347
2023-12-13
2023
50
347
5

348
2023-12-14
2023
50
348
6

349
2023-12-15
2023
50
349
7

350
2023-12-16
2023
51
350
1

351
2023-12-17
2023
51
351
2

352
2023-12-18
2023
51
352
3

353
2023-12-19
2023
51
353
4

354
2023-12-20
2023
51
354
5

355
2023-12-21
2023
51
355
6

356
2023-12-22
2023
51
356
7

357
2023-12-23
2023
52
357
1

358
2023-12-24
2023
52
358
2

359
2023-12-25
2023
52
359
3

360
2023-12-26
2023
52
360
4

361
2023-12-27
2023
52
361
5

362
2023-12-28
2023
52
362
6

363
2023-12-29
2023
52
363
7

364
2023-12-30
2023
53
364
1

365
2023-12-31
2023
53
365
2



SELECT 365


-- Finally
with base(gdate, woy) as 
     (select gegorian_date,  week_of_year
        from non_standard_calendar
        where gegorian_date  in ('2023-08-05'::date, '2023-08-12'::date)
     ) 
select to_char(gegorian_date, 'dd-mm-yyyy') "Dates"
     , 'Week_' || to_char(gdate, 'dd-Mon')  "Week"
  from non_standard_calendar
  join base on woy = week_of_year; 


Dates
Week


05-08-2023
Week_05-Aug

06-08-2023
Week_05-Aug

07-08-2023
Week_05-Aug

08-08-2023
Week_05-Aug

09-08-2023
Week_05-Aug

10-08-2023
Week_05-Aug

11-08-2023
Week_05-Aug

12-08-2023
Week_12-Aug

13-08-2023
Week_12-Aug

14-08-2023
Week_12-Aug

15-08-2023
Week_12-Aug

16-08-2023
Week_12-Aug

17-08-2023
Week_12-Aug

18-08-2023
Week_12-Aug



SELECT 14

nsw_id	gegorian_date	year	week_of_year	day_of_year	doy_of_week
1	2023-01-01	2023	1	1	1
2	2023-01-02	2023	1	2	2
3	2023-01-03	2023	1	3	3
4	2023-01-04	2023	1	4	4
5	2023-01-05	2023	1	5	5
6	2023-01-06	2023	1	6	6
7	2023-01-07	2023	2	7	1
8	2023-01-08	2023	2	8	2
9	2023-01-09	2023	2	9	3
10	2023-01-10	2023	2	10	4
11	2023-01-11	2023	2	11	5
12	2023-01-12	2023	2	12	6
13	2023-01-13	2023	2	13	7
14	2023-01-14	2023	3	14	1
15	2023-01-15	2023	3	15	2
16	2023-01-16	2023	3	16	3
17	2023-01-17	2023	3	17	4
18	2023-01-18	2023	3	18	5
19	2023-01-19	2023	3	19	6
20	2023-01-20	2023	3	20	7
21	2023-01-21	2023	4	21	1
22	2023-01-22	2023	4	22	2
23	2023-01-23	2023	4	23	3
24	2023-01-24	2023	4	24	4
25	2023-01-25	2023	4	25	5
26	2023-01-26	2023	4	26	6
27	2023-01-27	2023	4	27	7
28	2023-01-28	2023	5	28	1
29	2023-01-29	2023	5	29	2
30	2023-01-30	2023	5	30	3
31	2023-01-31	2023	5	31	4
32	2023-02-01	2023	5	32	5
33	2023-02-02	2023	5	33	6
34	2023-02-03	2023	5	34	7
35	2023-02-04	2023	6	35	1
36	2023-02-05	2023	6	36	2
37	2023-02-06	2023	6	37	3
38	2023-02-07	2023	6	38	4
39	2023-02-08	2023	6	39	5
40	2023-02-09	2023	6	40	6
41	2023-02-10	2023	6	41	7
42	2023-02-11	2023	7	42	1
43	2023-02-12	2023	7	43	2
44	2023-02-13	2023	7	44	3
45	2023-02-14	2023	7	45	4
46	2023-02-15	2023	7	46	5
47	2023-02-16	2023	7	47	6
48	2023-02-17	2023	7	48	7
49	2023-02-18	2023	8	49	1
50	2023-02-19	2023	8	50	2
51	2023-02-20	2023	8	51	3
52	2023-02-21	2023	8	52	4
53	2023-02-22	2023	8	53	5
54	2023-02-23	2023	8	54	6
55	2023-02-24	2023	8	55	7
56	2023-02-25	2023	9	56	1
57	2023-02-26	2023	9	57	2
58	2023-02-27	2023	9	58	3
59	2023-02-28	2023	9	59	4
60	2023-03-01	2023	9	60	5
61	2023-03-02	2023	9	61	6
62	2023-03-03	2023	9	62	7
63	2023-03-04	2023	10	63	1
64	2023-03-05	2023	10	64	2
65	2023-03-06	2023	10	65	3
66	2023-03-07	2023	10	66	4
67	2023-03-08	2023	10	67	5
68	2023-03-09	2023	10	68	6
69	2023-03-10	2023	10	69	7
70	2023-03-11	2023	11	70	1
71	2023-03-12	2023	11	71	2
72	2023-03-13	2023	11	72	3
73	2023-03-14	2023	11	73	4
74	2023-03-15	2023	11	74	5
75	2023-03-16	2023	11	75	6
76	2023-03-17	2023	11	76	7
77	2023-03-18	2023	12	77	1
78	2023-03-19	2023	12	78	2
79	2023-03-20	2023	12	79	3
80	2023-03-21	2023	12	80	4
81	2023-03-22	2023	12	81	5
82	2023-03-23	2023	12	82	6
83	2023-03-24	2023	12	83	7
84	2023-03-25	2023	13	84	1
85	2023-03-26	2023	13	85	2
86	2023-03-27	2023	13	86	3
87	2023-03-28	2023	13	87	4
88	2023-03-29	2023	13	88	5
89	2023-03-30	2023	13	89	6
90	2023-03-31	2023	13	90	7
91	2023-04-01	2023	14	91	1
92	2023-04-02	2023	14	92	2
93	2023-04-03	2023	14	93	3
94	2023-04-04	2023	14	94	4
95	2023-04-05	2023	14	95	5
96	2023-04-06	2023	14	96	6
97	2023-04-07	2023	14	97	7
98	2023-04-08	2023	15	98	1
99	2023-04-09	2023	15	99	2
100	2023-04-10	2023	15	100	3
101	2023-04-11	2023	15	101	4
102	2023-04-12	2023	15	102	5
103	2023-04-13	2023	15	103	6
104	2023-04-14	2023	15	104	7
105	2023-04-15	2023	16	105	1
106	2023-04-16	2023	16	106	2
107	2023-04-17	2023	16	107	3
108	2023-04-18	2023	16	108	4
109	2023-04-19	2023	16	109	5
110	2023-04-20	2023	16	110	6
111	2023-04-21	2023	16	111	7
112	2023-04-22	2023	17	112	1
113	2023-04-23	2023	17	113	2
114	2023-04-24	2023	17	114	3
115	2023-04-25	2023	17	115	4
116	2023-04-26	2023	17	116	5
117	2023-04-27	2023	17	117	6
118	2023-04-28	2023	17	118	7
119	2023-04-29	2023	18	119	1
120	2023-04-30	2023	18	120	2
121	2023-05-01	2023	18	121	3
122	2023-05-02	2023	18	122	4
123	2023-05-03	2023	18	123	5
124	2023-05-04	2023	18	124	6
125	2023-05-05	2023	18	125	7
126	2023-05-06	2023	19	126	1
127	2023-05-07	2023	19	127	2
128	2023-05-08	2023	19	128	3
129	2023-05-09	2023	19	129	4
130	2023-05-10	2023	19	130	5
131	2023-05-11	2023	19	131	6
132	2023-05-12	2023	19	132	7
133	2023-05-13	2023	20	133	1
134	2023-05-14	2023	20	134	2
135	2023-05-15	2023	20	135	3
136	2023-05-16	2023	20	136	4
137	2023-05-17	2023	20	137	5
138	2023-05-18	2023	20	138	6
139	2023-05-19	2023	20	139	7
140	2023-05-20	2023	21	140	1
141	2023-05-21	2023	21	141	2
142	2023-05-22	2023	21	142	3
143	2023-05-23	2023	21	143	4
144	2023-05-24	2023	21	144	5
145	2023-05-25	2023	21	145	6
146	2023-05-26	2023	21	146	7
147	2023-05-27	2023	22	147	1
148	2023-05-28	2023	22	148	2
149	2023-05-29	2023	22	149	3
150	2023-05-30	2023	22	150	4
151	2023-05-31	2023	22	151	5
152	2023-06-01	2023	22	152	6
153	2023-06-02	2023	22	153	7
154	2023-06-03	2023	23	154	1
155	2023-06-04	2023	23	155	2
156	2023-06-05	2023	23	156	3
157	2023-06-06	2023	23	157	4
158	2023-06-07	2023	23	158	5
159	2023-06-08	2023	23	159	6
160	2023-06-09	2023	23	160	7
161	2023-06-10	2023	24	161	1
162	2023-06-11	2023	24	162	2
163	2023-06-12	2023	24	163	3
164	2023-06-13	2023	24	164	4
165	2023-06-14	2023	24	165	5
166	2023-06-15	2023	24	166	6
167	2023-06-16	2023	24	167	7
168	2023-06-17	2023	25	168	1
169	2023-06-18	2023	25	169	2
170	2023-06-19	2023	25	170	3
171	2023-06-20	2023	25	171	4
172	2023-06-21	2023	25	172	5
173	2023-06-22	2023	25	173	6
174	2023-06-23	2023	25	174	7
175	2023-06-24	2023	26	175	1
176	2023-06-25	2023	26	176	2
177	2023-06-26	2023	26	177	3
178	2023-06-27	2023	26	178	4
179	2023-06-28	2023	26	179	5
180	2023-06-29	2023	26	180	6
181	2023-06-30	2023	26	181	7
182	2023-07-01	2023	27	182	1
183	2023-07-02	2023	27	183	2
184	2023-07-03	2023	27	184	3
185	2023-07-04	2023	27	185	4
186	2023-07-05	2023	27	186	5
187	2023-07-06	2023	27	187	6
188	2023-07-07	2023	27	188	7
189	2023-07-08	2023	28	189	1
190	2023-07-09	2023	28	190	2
191	2023-07-10	2023	28	191	3
192	2023-07-11	2023	28	192	4
193	2023-07-12	2023	28	193	5
194	2023-07-13	2023	28	194	6
195	2023-07-14	2023	28	195	7
196	2023-07-15	2023	29	196	1
197	2023-07-16	2023	29	197	2
198	2023-07-17	2023	29	198	3
199	2023-07-18	2023	29	199	4
200	2023-07-19	2023	29	200	5
201	2023-07-20	2023	29	201	6
202	2023-07-21	2023	29	202	7
203	2023-07-22	2023	30	203	1
204	2023-07-23	2023	30	204	2
205	2023-07-24	2023	30	205	3
206	2023-07-25	2023	30	206	4
207	2023-07-26	2023	30	207	5
208	2023-07-27	2023	30	208	6
209	2023-07-28	2023	30	209	7
210	2023-07-29	2023	31	210	1
211	2023-07-30	2023	31	211	2
212	2023-07-31	2023	31	212	3
213	2023-08-01	2023	31	213	4
214	2023-08-02	2023	31	214	5
215	2023-08-03	2023	31	215	6
216	2023-08-04	2023	31	216	7
217	2023-08-05	2023	32	217	1
218	2023-08-06	2023	32	218	2
219	2023-08-07	2023	32	219	3
220	2023-08-08	2023	32	220	4
221	2023-08-09	2023	32	221	5
222	2023-08-10	2023	32	222	6
223	2023-08-11	2023	32	223	7
224	2023-08-12	2023	33	224	1
225	2023-08-13	2023	33	225	2
226	2023-08-14	2023	33	226	3
227	2023-08-15	2023	33	227	4
228	2023-08-16	2023	33	228	5
229	2023-08-17	2023	33	229	6
230	2023-08-18	2023	33	230	7
231	2023-08-19	2023	34	231	1
232	2023-08-20	2023	34	232	2
233	2023-08-21	2023	34	233	3
234	2023-08-22	2023	34	234	4
235	2023-08-23	2023	34	235	5
236	2023-08-24	2023	34	236	6
237	2023-08-25	2023	34	237	7
238	2023-08-26	2023	35	238	1
239	2023-08-27	2023	35	239	2
240	2023-08-28	2023	35	240	3
241	2023-08-29	2023	35	241	4
242	2023-08-30	2023	35	242	5
243	2023-08-31	2023	35	243	6
244	2023-09-01	2023	35	244	7
245	2023-09-02	2023	36	245	1
246	2023-09-03	2023	36	246	2
247	2023-09-04	2023	36	247	3
248	2023-09-05	2023	36	248	4
249	2023-09-06	2023	36	249	5
250	2023-09-07	2023	36	250	6
251	2023-09-08	2023	36	251	7
252	2023-09-09	2023	37	252	1
253	2023-09-10	2023	37	253	2
254	2023-09-11	2023	37	254	3
255	2023-09-12	2023	37	255	4
256	2023-09-13	2023	37	256	5
257	2023-09-14	2023	37	257	6
258	2023-09-15	2023	37	258	7
259	2023-09-16	2023	38	259	1
260	2023-09-17	2023	38	260	2
261	2023-09-18	2023	38	261	3
262	2023-09-19	2023	38	262	4
263	2023-09-20	2023	38	263	5
264	2023-09-21	2023	38	264	6
265	2023-09-22	2023	38	265	7
266	2023-09-23	2023	39	266	1
267	2023-09-24	2023	39	267	2
268	2023-09-25	2023	39	268	3
269	2023-09-26	2023	39	269	4
270	2023-09-27	2023	39	270	5
271	2023-09-28	2023	39	271	6
272	2023-09-29	2023	39	272	7
273	2023-09-30	2023	40	273	1
274	2023-10-01	2023	40	274	2
275	2023-10-02	2023	40	275	3
276	2023-10-03	2023	40	276	4
277	2023-10-04	2023	40	277	5
278	2023-10-05	2023	40	278	6
279	2023-10-06	2023	40	279	7
280	2023-10-07	2023	41	280	1
281	2023-10-08	2023	41	281	2
282	2023-10-09	2023	41	282	3
283	2023-10-10	2023	41	283	4
284	2023-10-11	2023	41	284	5
285	2023-10-12	2023	41	285	6
286	2023-10-13	2023	41	286	7
287	2023-10-14	2023	42	287	1
288	2023-10-15	2023	42	288	2
289	2023-10-16	2023	42	289	3
290	2023-10-17	2023	42	290	4
291	2023-10-18	2023	42	291	5
292	2023-10-19	2023	42	292	6
293	2023-10-20	2023	42	293	7
294	2023-10-21	2023	43	294	1
295	2023-10-22	2023	43	295	2
296	2023-10-23	2023	43	296	3
297	2023-10-24	2023	43	297	4
298	2023-10-25	2023	43	298	5
299	2023-10-26	2023	43	299	6
300	2023-10-27	2023	43	300	7
301	2023-10-28	2023	44	301	1
302	2023-10-29	2023	44	302	2
303	2023-10-30	2023	44	303	3
304	2023-10-31	2023	44	304	4
305	2023-11-01	2023	44	305	5
306	2023-11-02	2023	44	306	6
307	2023-11-03	2023	44	307	7
308	2023-11-04	2023	45	308	1
309	2023-11-05	2023	45	309	2
310	2023-11-06	2023	45	310	3
311	2023-11-07	2023	45	311	4
312	2023-11-08	2023	45	312	5
313	2023-11-09	2023	45	313	6
314	2023-11-10	2023	45	314	7
315	2023-11-11	2023	46	315	1
316	2023-11-12	2023	46	316	2
317	2023-11-13	2023	46	317	3
318	2023-11-14	2023	46	318	4
319	2023-11-15	2023	46	319	5
320	2023-11-16	2023	46	320	6
321	2023-11-17	2023	46	321	7
322	2023-11-18	2023	47	322	1
323	2023-11-19	2023	47	323	2
324	2023-11-20	2023	47	324	3
325	2023-11-21	2023	47	325	4
326	2023-11-22	2023	47	326	5
327	2023-11-23	2023	47	327	6
328	2023-11-24	2023	47	328	7
329	2023-11-25	2023	48	329	1
330	2023-11-26	2023	48	330	2
331	2023-11-27	2023	48	331	3
332	2023-11-28	2023	48	332	4
333	2023-11-29	2023	48	333	5
334	2023-11-30	2023	48	334	6
335	2023-12-01	2023	48	335	7
336	2023-12-02	2023	49	336	1
337	2023-12-03	2023	49	337	2
338	2023-12-04	2023	49	338	3
339	2023-12-05	2023	49	339	4
340	2023-12-06	2023	49	340	5
341	2023-12-07	2023	49	341	6
342	2023-12-08	2023	49	342	7
343	2023-12-09	2023	50	343	1
344	2023-12-10	2023	50	344	2
345	2023-12-11	2023	50	345	3
346	2023-12-12	2023	50	346	4
347	2023-12-13	2023	50	347	5
348	2023-12-14	2023	50	348	6
349	2023-12-15	2023	50	349	7
350	2023-12-16	2023	51	350	1
351	2023-12-17	2023	51	351	2
352	2023-12-18	2023	51	352	3
353	2023-12-19	2023	51	353	4
354	2023-12-20	2023	51	354	5
355	2023-12-21	2023	51	355	6
356	2023-12-22	2023	51	356	7
357	2023-12-23	2023	52	357	1
358	2023-12-24	2023	52	358	2
359	2023-12-25	2023	52	359	3
360	2023-12-26	2023	52	360	4
361	2023-12-27	2023	52	361	5
362	2023-12-28	2023	52	362	6
363	2023-12-29	2023	52	363	7
364	2023-12-30	2023	53	364	1
365	2023-12-31	2023	53	365	2

Dates	Week
05-08-2023	Week_05-Aug
06-08-2023	Week_05-Aug
07-08-2023	Week_05-Aug
08-08-2023	Week_05-Aug
09-08-2023	Week_05-Aug
10-08-2023	Week_05-Aug
11-08-2023	Week_05-Aug
12-08-2023	Week_12-Aug
13-08-2023	Week_12-Aug
14-08-2023	Week_12-Aug
15-08-2023	Week_12-Aug
16-08-2023	Week_12-Aug
17-08-2023	Week_12-Aug
18-08-2023	Week_12-Aug