excel合同到期提醒全公式

INT((TODAY()-E2)/365)

DATE(YEAR(B18)+1,MONTH(B18),DAY(B1 IF(VALUE(MID(D2,15,3))/2=INT(VALUE(MID(D2,15,3))/2),"女","男

DATE(YEAR(P3),MONTH(P3)+3,DAY

INT((TODAY()-E2)/365)

ATE(YEAR(B18)+1,MONTH(B18),DAY(B18))

NT(VALUE(MID(D2,15,3))/2),"女","男")

E(YEAR(P3),MONTH(P3)+3,DAY(P3)-1)