豪~豪的个人中心=CONCATENATE(RIGHT(YEAR(TODAY()),2),IF(LEN(WEEKNUM(TODAY(),2))=1,"0",""),WEEKNUM(TODAY(),2))
Excel公式日期转换成年周
未经允许不得转载：豪~豪的个人中心 » Excel公式日期转换成年周
欢迎光临
我们一直在努力
我们一直在努力
=CONCATENATE(RIGHT(YEAR(TODAY()),2),IF(LEN(WEEKNUM(TODAY(),2))=1,"0",""),WEEKNUM(TODAY(),2))
