Question

如何用EXCEL表计算今天是本年的第几周？

Answer 1

Excel 2007

一周按周日开始计算:
=WEEKNUM(TODAY())
=WEEKNUM(TODAY(),1)

一周按周一开始计算:
=WEEKNUM(TODAY(),2)

Answer 2

=INT((TODAY()-DATE(YEAR(TODAY()),1,1)-WEEKDAY(DATE(YEAR(TODAY()),1,1),2))/7)+1