how to get date from week and day in appsheet

AppSheet AppSheet Q&A
1

stiil search how to get dete from week and day anyone can help?

2

You mean you start with something like “week 13 , Monday” and want Feb 27th?

You could do something like “1/1/2023” + (([week]-1) * 7) + SWITCH( [day] , “Mon”,1,"Tue,2…)

Or do you mean something else?

2 Likes
3

i have column week and day and i need date form it?
week = 1

day = monday

date =?

if i change wee to “2” then day to sunday and i need date ?

4

try to used (TODAY() - WEEKDAY(TODAY()) + SWITCH([hari],“Ahad”,”1”,“isnin”,”2”,“Selasa”,”3”,“rabu”,“4”,
”Khamis”,“5”,“Jumaat”,“6”,“sabtu”,“7”,””))

but return error