Date of 1st Monday of an ISOWEEK taking into consideration [Week] & [Year] variable

Can someone support me in converting the following excel formula into a AppSheet compatible expression? 

=DATE(G3, 1, 1) + ( H3 - 1) * 7 - WEEKDAY(DATE(G3, 1, 1), 2) + 1

Skip2MiLu_0-1703161620048.png

 

0 1 115
1 REPLY 1

Hey man,

it's pretty simple:
INDEX(EXTRACTDATES(CONCATENATE([Year])), 1) + MOD(9 - WEEKDAY(INDEX(EXTRACTDATES(CONCATENATE([Year])), 1)), 7) + 7 * ([Week] - 1)

Cheers

Top Labels in this Space