|
0
|
华莉星宸Lv7资深互助发布于2024-10-15 16:19
|
SWITCH(WEEKDAY(todate(A4)), 0, "星期日", 1, "星期一", 2, "星期二", 3, "星期三", 4, "星期四", 5, "星期五", 6, "星期六") |
-
haipa(提问者)
- 你好，图片已经更新，星期几还是出错
-
华莉星宸 回复 haipa(提问者)
- =SWITCH(WEEKDAY(todate(date(left(A4,4),mid(A4,5,2),right(A4,2)))), 0, "星期日", 1, "星期一", 2, "星期二", 3, "星期三", 4, "星期四", 5, "星期五", 6, "星期六")
-
haipa(提问者)
- 你好，请问一下我用format((B4),"EEEEE")出现的为什么是英文的星期几
-
华莉星宸 回复 haipa(提问者)
- format(today(),"yyyy-MM-dd EEEEE","zh")
|
|
|
0
|
水清天蓝Lv7初级互助发布于2024-10-15 16:28
|
SWITCH(WEEKDAY(format(A4,"yyyy/MM/dd")), 0, "星期日", 1, "星期一", 2, "星期二", 3, "星期三", 4, "星期四", 5, "星期五", 6, "星期六") |
|
|
|
1min目标场景问卷
立即参与
