Extracting Date from Week number

[Antoan]

Hello everyone!


Do you know how i can extract the exact date from the number of the week in that instance:

VIA FC competition output 2022 - week 6 (1).xlsx
	C	D	E	F
5	Years	Date	Weeks	Sales
6	2017		Week 1	-
7			Week 2	-
8			Week 3	-
9			Week 4	-
10			Week 5	-
11			Week 6	-
12			Week 7	-
13			Week 8	-
14			Week 9	-
15			Week 10	-
16			Week 11	-
17			Week 12	-
18			Week 13	-
19			Week 14	-
20			Week 15	-
21			Week 16	-
22			Week 17	-
23			Week 18	-
24			Week 19	-
25			Week 20	-
26			Week 21	-
27			Week 22	-
28			Week 23	-
29			Week 24	-
30			Week 25	-
31			Week 26	-
32			Week 27	-
33			Week 28	-
34			Week 29	-
35			Week 30	-
36			Week 31	-
37			Week 32	-
38			Week 33	-
39			Week 34	-
40			Week 35	-
41			Week 36	-
42			Week 37	-
43			Week 38	-
44			Week 39	-
45			Week 40	-
46			Week 41	-
47			Week 42	-
48			Week 43	-
49			Week 44	-
50			Week 45	-
51			Week 46	-
52			Week 47	-
53			Week 48	-
54			Week 49	-
55			Week 50	-
56			Week 51	-
57			Week 52	-
58	2018		Week 1	-
Toilet Paper

Thank you in advance for your help!

 

[BSALV]

ISO-week (europe & ...) or other week ?

 

[Antoan]

ISO-week (europe & ...) or other week ?

ISO weeks, yes!

 

[BSALV]

3.1 in VBA for smarties ISO weeknumber
weekday : 1 (mon) to 7 (sun)

Map1
	A	B	C	D
1	year	2021
2	week	1		ma 04/01/21
3	day	1
Blad2

Cell Formulas
Range	Formula
D2	D2	=7*(B2-1)+DATE(B1,1,4)- WEEKDAY(DATE(B1,1,4), 2)+B3

 

[BSALV]

with weeknumber

Map1
	A	B	C	D
1	year	2021
2	week	1		ma 04/01/21
3	day	1
4
5		week 51		ma 20/12/21
6		week 1		ma 04/01/21
Blad2

Cell Formulas
Range	Formula
D2	D2	=7*(B2-1)+DATE($B$1,1,4)- WEEKDAY(DATE($B$1,1,4), 2)+$B$3
D5:D6	D5	=7*(RIGHT(B5,2)-1)+DATE($B$1,1,4)- WEEKDAY(DATE($B$1,1,4), 2)+$B$3

 

[Antoan]

Thank you so much!