提取星期数转换为汉字星期几显示

pobopo · 发表于 2018-12-25 18:14:26

"星期"&right(left("日一二三四五六",MFWEEKDAY($MF(日期)$)),1)

showph · 发表于 2019-8-15 18:04:58

又一写法：
MFE(MOD($MF(日期)$,7)+1,MFV("星期六","星期日","星期一","星期二","星期三","星期四","星期五"))

showph · 发表于 2019-8-15 18:09:19

showph 发表于 2019-8-15 18:04
又一写法：
MFE(MOD($MF(日期)$,7)+1,MFV("星期六","星期日","星期一","星期二","星期三","星期四","星期 ...

"星期"&MFE(MOD($MF(检查日期)$,7)+1,MFV("六","日","一","二","三","四","五"))

		自动登录	找回密码
密码			注册

[原创] 提取星期数转换为汉字星期几显示