how to get date from week and day in appsheet

[ismaeditor]

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

[Marc_Dillon]

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?

[ismaeditor]

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

[ismaeditor]

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 ?