如何进行日期计算有效期计算，J4代表着检验日期，Excel计算出有效期是1年的公式=DATE(YEAR(J4)+1,MONTH(J4),DAY(J4)-1)
检验日期
检验标识
下次检定日期
2021/6/1
合格期
2022/5/31
检验标识用条件语句判断=IF(DAYS360(TODAY(),DATE(YEAR(J4)+1,MONTH(J4),DAY(J4)-1))>=30,"合格期",IF(AND(DAYS360(TODAY(),DATE(YEAR(J4)+1,MONTH(J4),DAY(J4)-1))<30,DAYS360(TODAY(),DATE(YEAR(J4)+1,MONTH(J4),DAY(J4)-1))>=0),"已到期",IF(DAYS360(TODAY(),DATE(YEAR(J4)+1,MONTH(J4),DAY(J4)-1))<0,"已超期")))，
加好友 
发短信
Post By：2021/12/30 19:34:00 [只看该作者]
