假设你的文本日期在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