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

AppSheet AppSheet Q&A
1

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
Skip2MiLu_0-1703161620048.png911×590 29.7 KB

2

Hey man,

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

Cheers