CHOOSE(WEEKDAY(D2,2),"星期一","星期二","星期三","星期四","星期五","星期六","星期日")
有没有解决的方式~
format("2023-06-25","EEE")
format(d2,"EEE")/*单元格*/
你是要日期返回大写的星期直接
switch(weekday(d2),0,"星期天",1,"星期一",2,"星期二",3,"星期三",4,"星期四",5,"星期五",6,"星期六")