stiil search how to get dete from week and day anyone can help?
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?
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
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 ?
User | Count |
---|---|
43 | |
26 | |
26 | |
16 | |
11 |