由于公司的原因，从3月1号开始算新的1年，这样的话，345，算是第一个季度，678是第二个，然后按照自然月来算，3月1号至3月3号算是第一周，然后3月4日至10日算是第二周，这样排下去，然后等到6月1号的时候，6月1号至2号算是第二季度的第一周，前面的5月27号~31号算是上个季度的最后一周，我现在按照当前日期判断，需要把这个第几周提交入库，请教大佬怎么计算么，

poseidon大佬帮忙写了，公司如下

"第" + NUMTO(IF(DATEDIF(if(or(month(today()) = "3", month(today()) = "4", month(today()) = "5"), CONCATENATE(YEAR(today()), "-03-01"), if(or(month(today()) = "6", month(today()) = "7", month(today()) = "8"), CONCATENATE(YEAR(today()), "-06-01"), if(or(month(today()) = "9", month(today()) = "10", month(today()) = "11"), CONCATENATE(YEAR(today()), "-09-01"), if(month(today()) = "12", CONCATENATE(YEAR(today()), "-12-01"), CONCATENATE(YEAR(today()) - 1, "-12-01"))))), today(), "D") > 7 || WEEK(today()) <> WEEK(if(or(month(today()) = "3", month(today()) = "4", month(today()) = "5"), CONCATENATE(YEAR(today()), "-03-01"), if(or(month(today()) = "6", month(today()) = "7", month(today()) = "8"), CONCATENATE(YEAR(today()), "-06-01"), if(or(month(today()) = "9", month(today()) = "10", month(today()) = "11"), CONCATENATE(YEAR(today()), "-09-01"), if(month(today()) = "12", CONCATENATE(YEAR(today()), "-12-01"), CONCATENATE(YEAR(today()) - 1, "-12-01")))))), IF(WEEKDAY(today()) = 0, ROUNDUP((DATEDIF(if(or(month(today()) = "3", month(today()) = "4", month(today()) = "5"), CONCATENATE(YEAR(today()), "-03-01"), if(or(month(today()) = "6", month(today()) = "7", month(today()) = "8"), CONCATENATE(YEAR(today()), "-06-01"), if(or(month(today()) = "9", month(today()) = "10", month(today()) = "11"), CONCATENATE(YEAR(today()), "-09-01"), if(month(today()) = "12", CONCATENATE(YEAR(today()), "-12-01"), CONCATENATE(YEAR(today()) - 1, "-12-01"))))), today(), "D") - WEEKDAY(today())) / 7, 0), ROUNDUP((DATEDIF(if(or(month(today()) = "3", month(today()) = "4", month(today()) = "5"), CONCATENATE(YEAR(today()), "-03-01"), if(or(month(today()) = "6", month(today()) = "7", month(today()) = "8"), CONCATENATE(YEAR(today()), "-06-01"), if(or(month(today()) = "9", month(today()) = "10", month(today()) = "11"), CONCATENATE(YEAR(today()), "-09-01"), if(month(today()) = "12", CONCATENATE(YEAR(today()), "-12-01"), CONCATENATE(YEAR(today()) - 1, "-12-01"))))), today(), "D") - WEEKDAY(today())) / 7 + 1, 0)), 1)) + "周"