在EXCEL 2007版一张考勤表中,如何让数据记录随着1-12月份变化而自动变化?

2025-04-09 00:17:31
推荐回答(2个)
回答1:

=IFERROR(LOOKUP(G1,{1,2,3,4,5,6,7,7,8,9,11,12,13},{"一月","二月","三月","四月","五月","六月","七月","八月","九月","十月","十一月","十二月"}),"")
如果需要时间自动匹配,可用=now() 和 =month() 等函数实现。

回答2:

现在后面的日期怎么做出来的?