在魔方网表里面利用日期字段自动识别成为星期几

魔方的公式和Excel公式完全兼容，那么可以通过weekday函数将日期转化正星期的数字，在通过if函数将数字转化成为“星期几”字样，
例如：
if(TEXT(WEEKDAY($MF(日期)$,2),"0")="1","星期一",if(TEXT(WEEKDAY($MF(日期)$,2),"0")="2","星期二",if(TEXT(WEEKDAY($MF(日期)$,2),"0")="3","星期三",if(TEXT(WEEKDAY($MF(日期)$,2),"0")="4","星期四",if(TEXT(WEEKDAY($MF(日期)$,2),"0")="5","星期五",if(TEXT(WEEKDAY($MF(日期)$,2),"0")="6","星期六",if(TEXT(WEEKDAY($MF(日期)$,2),"0")="7","星期日",0)))))))
其中“日期”字段可换为其他任何日期

把TEXT的第二个参数，改成"dddd"，不用IF，你再试试。