Return the date of the 1st monday of the relevant week using the relevant year of TODAY()

I looking for a column Description expression that will return the following text value for column 1 (i.e. Week 1)

Wk 1: Mon, 2 Jan 2023

It does this by looking at the Column Name number 1 as well as the year of Today() i.e. 2023 and then returns the date of the 1st monday of week 1.

I not sure if you able to return the relevant column name dynamically within Appsheet, but I do not mind "hard coding" the week numbers for each column expression (i.e. 1, 2, 3....)
Also factor in that I am using an ISO week numbering type 
ISO week date - Wikipediar

Skip2MiLu_1-1700862850167.png

 

Skip2MiLu_0-1700862214904.png

 

0 17 866
17 REPLIES 17