Week number and year to Date

[KS]

Hello, 

I need you help please, I have two columns, one with the year and one with the week number, Sunday 1st January being week 1.

I want to return the Friday date for each row but for week 1, I want it to return the Sunday.

Example : for week 28 of year 2023, the date should be 07/07/2023 / week 1 of year 2023, the day should be 01/01/2023/ week 2 of year 2023, the date should be 01/06/2023. 

I got it in excel but don't know how to put it in Alteryx.

Attached is the sample to use to get the date. 

I hope you can help me.  

Thank you in advance

[KS · Accepted solution]

Hi  @caltang

It did work for Sunday but not for Friday.

I used your method for Sunday and another one for Friday. Attached is the final flow used. 

Thanks a lot for your help.

[caltang]

No prob! Kindly mark my solution as an accepted solution. Thanks!