提供几个EXCEL中取日期在第几周的函数

[[{"txt": "\u00a0 \u00a0 \u00a0 \u5728EXCEL\u4e2d\u5982\u4f55\u5199\u51fd\u6570\u53d6\u65e5\u671f\u5728\u7b2c\u51e0\u5468\uff0c\u4f46\u7a0d\u5fae\u6709\u4e9b\u4e0d\u540c\u7684\u662f\u4e00\u5e74\u7684\u6700\u521d\u51e0\u5929\u5982\u679c\u63a5\u7740\u4e0a\u4e00\u5e74\u8981\u7b97\u5230\u4e0a\u4e00\u5e74\u4e2d\u53bb\uff0c\u6bd4\u5982\u8bf42010\u5e741\u67082\u65e5\uff0c\u7ed3\u679c\u5e94\u8be5\u662f52\uff0c\u800c\u4e0d\u662f1\u3002"}, {"txt": "\u7c97\u7565\u4e00\u60f3\uff0c\u8fd9\u4e2a\u51fd\u6570\u5176\u5b9e\u86ee\u590d\u6742\u7684\uff0c\u5199\u4e86\u5f88\u591a\u6b21\uff0c\u90fd\u5728\u67d0\u4e9b\u60c5\u51b5\u4e0b\u5f97\u4e0d\u5230\u6b63\u786e\u7684\u7ed3\u679c\uff0c\u6700\u540e\u8fd9\u6837\u6210\u529f\u4e86\uff1a"}, {"txt": "\u65b9\u6cd5\u4e00\uff1a"}, {"txt": "=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))"}, {"txt": "\u5176\u4e2dA1\u662f\u8981\u8ba1\u7b97\u7684\u5355\u5143\u683c\uff0c\u53e6\u5916\u8fd9\u4e2a\u662f\u6309\u7167\u4e2d\u56fd\u7684\u4e60\u60ef\uff0c\u4e5f\u5c31\u662f\u8bf4\u4e00\u5468\u662f\u4ece\u661f\u671f\u4e00\u5f00\u59cb\u5230\u661f\u671f\u65e5\u7ed3\u675f\u7684\uff0c\u5982\u679c\u8981\u6309\u7167\u7f8e\u56fd\u7684\u4e60\u60ef\uff0c\u53ea\u8981\u5c06WEEKDAY\u7684\u7b2c2\u4e2a\u53c2\u6570\u6539\u62101\u5c31\u884c\u4e86\u3002"}, {"txt": "\u65b9\u6cd5\u4e8c\uff1a"}, {"txt": "=INT(((A2-VALUE(YEAR(A2)&-1&-1))+WEEKDAY(VALUE(YEAR(A2)&-1&-1))-1)/7)"}, {"txt": "\u65b9\u6cd5\u4e09\uff1a\u51fd\u6570WEEKNUM(serial_num,return_type)\u8fd4\u56de\u4e00\u4e2a\u65e5\u671f\u5728\u8be5\u5e74\u4e2d\u7b2c\u51e0\u5468\u7684\u6570\u5b57\u3002\u5176\u4e2d\u53c2\u6570return_type\u4e3a1\u8868\u793a\u4ece\u661f\u671f\u65e5\u5f00\u59cb\u81f3\u661f\u671f\u516d\u7b97\u4e00\u5468\uff0c\u4e3a2\u8868\u793a\u4ece\u661f\u671f\u4e00\u5f00\u59cb\u81f3\u661f\u671f\u65e5\u7b97\u4e00\u5468\u3002\u00a0\u00a0\u00a0\u5982B1\u5355\u5143\u683c\u5305\u542b\u65e5\u671f\u503c2006-1-2\uff0c\u4e0b\u9762\u7684\u516c\u5f0f\u5206\u522b\u8fd4\u56de\u6570\u5b571\u548c2\uff0c\u4ee3\u8868\u7b2c\u4e00\u5468\u548c\u7b2c\u4e8c\u5468\u30022006-1-1\u662f\u661f\u671f\u65e5\uff0c\u82e5return_type\u4e3a1\u5219\u4ece2006-1-1\u81f32006-1-7\u65e5\u4e3a\u7b2c\u4e00\u5468\uff0c\u82e5return_type\u4e3a2\u52192006-1-1\u4e3a\u7b2c\u4e00\u5468\uff0c\u4ece2006-1-2\u81f32006-1-8\u4e3a\u7b2c2\u5468\u3002=WEEKNUM(B1,1)=WEEKNUM(B1,2)\u00a0\u00a0\u00a0\u6ce8\u610f:\u00a0\u00a0\u00a0\u00a0\u00a0\u5148\u52a0\u8f7d\"\u5206\u6790\u5de5\u5177\u5e93\"\u624d\u80fd\u4f7f\u7528WEEKNUM\u51fd\u6570\u3002\u52a0\u8f7d\u7684\u65b9\u6cd5\u662f\u5355\u51fb\u83dc\u5355\"\u5de5\u5177\"\uff0d\"\u52a0\u8f7d\u5b8f\"\uff0c\u5728\"\u52a0\u8f7d\u5b8f\"\u5bf9\u8bdd\u6846\u4e2d\u52fe\u9009\"\u5206\u6790\u5de5\u5177\u5e93\"\u590d\u9009\u6846\uff0c\u6700\u540e\u5355\u51fb\"\u786e\u5b9a\"\u6309\u94ae\u3002\u3002"}]]