Excel如何设置生日倒数日循环？
发布网友
发布时间：2022-03-23 21:02
共3个回答
热心网友
时间：2022-03-23 22:31
在C2单元格输入
=DATEDIF(TODAY(),DATE(YEAR(TODAY())+IF(DATE(YEAR(TODAY()),MONTH(B2),DAY(B2))<=TODAY(),1,0),MONTH(B2),DAY(B2)),"YD")
详见附图示例
热心网友
时间：2022-03-23 23:49
C2单元格公式=IF(DATE(YEAR(TODAY()),MONTH(B2),DAY(B2))<TODAY(),DATEDIF(DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())),DATE(YEAR(TODAY())+1,MONTH(B2),DAY(B2)),"d"),DATEDIF(TEXT(TODAY(),"m/d"),TEXT(B2,"m/d"),"d"))
下拉。
热心网友
时间：2022-03-24 01:24
年龄列数据要动态当前月，日=出生月，日时年龄自动+1
