Excel小技巧

=IF(EXACT(WEEKDAY(A10,2),"1"),"一",IF(EXACT(WEEKDAY(A10,2),"2"),"二",IF(EXACT(WEEKDAY(A10,2),"3"),"三",IF(EXACT(WEEKDAY(A10,2),"4"),"四",IF(EXACT(WEEKDAY(A10,2),"5"),"五",IF(EXACT(WEEKDAY(A10,2),"6"),"六",IF(EXACT(WEEKDAY(A10,2),"7"),"日","")))))))

发表回复

您的电子邮箱地址不会被公开。 必填项已用 * 标注