如何把WPS表格里面的日期拆分出时间(几十几分几秒)和周几?

2025-03-07 02:08:32
推荐回答(1个)
回答1:

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"))