中国周历表与SAP标准周历表错位一周问题求解？

alankang

WEEKNUM函数使用时要注意2种情况：

•System 1  The week containing January 1 is the first week of the year, and is numbered week 1. 按1月1日作为第一周计数

•System 2  The week containing the first Thursday of the year is the first week of the year, and is numbered as week 1. 如果当年第一周包含周四，则为第1周

因此，若要使用Weeknum函数，请增加合适的参数：=WEEKNUM("2016-4-28",21)，指定返回类型为21即可得到合适的周数17。

alankang

alankang 发表于 2016-5-23 11:29
2017也是错位的

WEEKNUM函数使用时要注意2种情况：

•System 1  The week containing January 1 is the first week of the year, and is numbered week 1. 按1月1日作为第一周计数

•System 2  The week containing the first Thursday of the year is the first week of the year, and is numbered as week 1. 如果当年第一周包含周四，则为第1周

因此，若要使用Weeknum函数，请增加合适的参数：=WEEKNUM("2016-4-28",21)，指定返回类型为21即可得到合适的周数17。