先把ab列设置为常规a3单元格输入=TEXT(DATE(,2,ROW(A1)),"m.d")下拉b3单元格=TEXT(WEEKDAY(SUBSTITUTE(A1,".","-"),1),"aaaa")下拉ok