B2公式下拉:
=IF(A2="","",SUBSTITUTE(A2,LEFT(A2,FIND("日",A2)),))
C2公式下拉(显示为星期几):
=IF(A2="","",TEXT(LEFT(A2,FIND("日",A2)),"aaaa"))
C2公式下拉(显示为周几):
=IF(A2="","",TEXT(LEFT(A2,FIND("日",A2)),"周aaa"))