excel日期表设置20201215

最新推荐文章于 2024-12-02 15:13:10 发布

原创最新推荐文章于 2024-12-02 15:13:10 发布 · 1.1k 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#excel

收录于

Excel 专栏收录该内容

12 篇文章

订阅专栏

本文详细讲解了Excel中的日期函数如=TEXT(A2,YYYY年)、=MONTH(A2)等，以及与日期相关的WEEKDAY、WEEK数计算，展示了如何利用这些工具处理和格式化日期数据。同时涵盖了季度划分、星期几识别和IT领域的季节性标签。

=TEXT(A2,"YYYY年")
=TEXT(A2,"M月")
=TEXT(A2,"d日")
=YEAR(A2)
=MONTH(A2)
=DAY(A2)
=WEEKNUM(A2)
= IF(WEEKNUM(A2,2)-1 = 0,WEEKNUM(DATE(YEAR(A2)-1,12,31),2),WEEKNUM(A2,2)-1)
=WEEKDAY(A2)
=LOOKUP(WEEKDAY(A2,2),{1,2,3,4,5,6,7;"星期一","星期二","星期三","星期四","星期五","星期六","星期日"})
=LOOKUP(LEN(2^MONTH(A2)),{1,2,3,4;"第一季度","第二季度","第三季度","第四季度"})
=LEN(2^MONTH(A2))