Excel插入日期:当天的年月日和星期

在A1输入:

=TEXT(TODAY(),"YYYY年MM月DD日AAAA")

或者

=TEXT(NOW(),"e-m-d aaaa")

表示今天的日期和相对应的星期几

YYYY年MM月DD日 //年月日
AAAA //星期

Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.