Excel 2007一周按周日开始计算:=WEEKNUM(TODAY())=WEEKNUM(TODAY(),1)一周按周一开始计算:=WEEKNUM(TODAY(),2)
=INT((TODAY()-DATE(YEAR(TODAY()),1,1)-WEEKDAY(DATE(YEAR(TODAY()),1,1),2))/7)+1
