如何设置到期提醒

寒沙

工作状态在职情况下：当留存期为三天时，在职天数大于等于三天时为结算，小于三天时为未到期，当留存期为七天时，在职天数大于等于七天为结算，小于七天时为未到期
工作状态离职情况下：留存期为三天时在职天数小于三天为不结算，留存期为七天时在职天数小于七天为不结算，

tony@cq

H3=IF(AND(OR(J3="在职",J3="培训"),OR(LEFT(G3)-0=3,DATEDIF(D3,TODAY(),"D")>=3,LEFT(G3)-0=7,DATEDIF(D3,TODAY(),"D")>=7)),"结算",IF(AND(OR(J3="在职",J3="培训"),OR(LEFT(G3)-0=3,DATEDIF(D3,TODAY(),"D")<3,LEFT(G3)-0=7,DATEDIF(D3,TODAY(),"d")<7)),"未到期",IF(OR(AND(J3="离职",LEFT(G3)-0=3,DATEDIF(D3,F3,"D")<3),AND(J3="离职",LEFT(G3)-0=7,DATEDIF(D3,F3,"D")<7)),"不结算")))，下拉公式。