单元格内输入如下代码计算出来的数字即是当日在本年度的第几周,如下:
=INT((TODAY()-DATE(YEAR(TODAY()),1,1)-WEEKDAY(DATE(YEAR(TODAY()),1,1),2))/7)+1
05-04 00:17