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

发表评论

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

此站点使用Akismet来减少垃圾评论。了解我们如何处理您的评论数据