假设你的文本日期在A1单元格，格式为yyyy-mm-dd。你可以在B1单元格中使用以下公式来提取年份和周次：
```excel
=TEXT(A1, yyyy)&-&TEXT(INT((A1-INT((A1-INT((A1-INT((A1-INT((A1-INT((A1-INT((A1-INT((A1-INT((A1-INT((A1-INT((A1-INT((A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1-INT(A1
原创文章，作者：LifeTo.Fun，如若转载，请注明出处：https://www.lifeto.fun/archives/762
