How to find first date of country Week

[kenan_turker]

Dear Community, 

I am looking for a solution to find first date of the country week for the related year. 

I have a put a simple table as below including year and week information. Could you please let me know how to produce the dates beside question marks?

Year	Week	First date of the Week
2022	22	? (23.05.2022)
2022	36	? (29.08.2022)

Thanks 

[ShankerV]

Hi @kenan_turker 

One way of doing this.

Many thanks

Shanker V

[binuacs]

@kenan_turker Another method of finding the first date from the given week number

[Yoshiro_Fujimori · Accepted solution]

@kenan_turker ,

Another solution.

Using Formula tool only.

FirstDayOfYear = ToString([Year]) + "-01-01"

AddWeeks = DateTimeAdd([FirstDayOfYear],([Week]-1)*7,"days")

DayOfWeek = ToNumber(DateTimeFormat([AddWeeks],"%w"))

First date of the Week = DateTimeAdd([AddWeeks],-[DayOfWeek]+1,"days")

Check = DateTimeFormat([First date of the Week],"%a")

Output