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
Hey man,
it's pretty simple:
INDEX(EXTRACTDATES(CONCATENATE([Year])), 1) + MOD(9 - WEEKDAY(INDEX(EXTRACTDATES(CONCATENATE([Year])), 1)), 7) + 7 * ([Week] - 1)
Cheers
User | Count |
---|---|
15 | |
14 | |
8 | |
7 | |
4 |