作者：乔山办公网日期：
返回目录：excel表格制作
=WEEKNUM(TODAY())
这个是今天处于今年第几周
如果是其它日期，比如你日期填写在A1单元格，则在B1输入
=WEEKNUM(A1)
注意，将输入公式的单元格设置为“常规”
1、按照每月计算度周
=YEAR(A1) & "年" & MONTH(A1) & "月知" & "第" & INT(DAY(A1)/7+1) & "周道"
2、按照日历计算版周权
=IF(AND(WEEKDAY(DATE(YEAR(A1),1,1),2) > 1,FLOOR(DATEDIF(DATE(YEAR(A1),1,1),A1+WEEKDAY(DATE(YEAR(A1),1,1)-8,2),"D")/7,1)=0), FLOOR(DATEDIF(DATE(YEAR(A1)-1,1,1),DATE(YEAR(A1),1,1)+WEEKDAY(DATE(YEAR(A1)-1,1,1)-8,2),"D")/7,1), FLOOR(DATEDIF(DATE(YEAR(A1),1,1),A1+WEEKDAY(DATE(YEAR(A1),1,1)-8,2),"D")/7,1))
3、按照日历计算周（区别上年最后一周(0)，本年最后一周(52)）
=ROUNDUP((A1-DATE(YEAR(A1),1,)+MOD(WEEKDAY(DATE(YEAR(A1),1,),2),7))/7,0)-1