##工作周报自动日期
=TEXT(YEAR(TODAY()),"###") & "年第" & TEXT(WEEKNUM(TODAY()),"###") & "周(" & TEXT(TODAY()-WEEKDAY(TODAY())+2,"yyyy/mm/dd") & " ~ " & TEXT(TODAY()-WEEKDAY(TODAY())+8,"yyyy/mm/dd") & ")"
2017年第42周(2017/10/16 ~ 2017/10/22)
##工作周报自动日期
=TEXT(YEAR(TODAY()),"###") & "年第" & TEXT(WEEKNUM(TODAY()),"###") & "周(" & TEXT(TODAY()-WEEKDAY(TODAY())+2,"yyyy/mm/dd") & " ~ " & TEXT(TODAY()-WEEKDAY(TODAY())+8,"yyyy/mm/dd") & ")"
2017年第42周(2017/10/16 ~ 2017/10/22)