Excel 2010 得到当天的日期/得到一年中的第几周/得到当前一周中的星期几

 

=TODAY()

 

="第"&WEEKNUM(TODAY())&"周"

=TEXT(TODAY(),"aaaa")

 

Ctrl + `  

 

 

 

="XX部门第"&WEEKNUM(TODAY())&"周周报"

posted @ 2017-12-16 17:59  行走的思想  阅读(351)  评论(0)    收藏  举报