=TODAY()
="第"&WEEKNUM(TODAY())&"周"
=TEXT(TODAY(),"aaaa")
Ctrl + `
="XX部门第"&WEEKNUM(TODAY())&"周周报"
=TODAY()
="第"&WEEKNUM(TODAY())&"周"
=TEXT(TODAY(),"aaaa")
Ctrl + `
="XX部门第"&WEEKNUM(TODAY())&"周周报"
Excel 2010 得到当天的日期/得到一年中的第几周/得到当前一周中的星期几
原文：http://www.cnblogs.com/onelikeone/p/8047227.html