=IF(DATEDIF(G8,H8,"M")>11,IF(MOD(DATEDIF(G8,H8,"M"),12)=0,DATEDIF(G8,H8,"Y")*50/DAY(EOMONTH(H8,0))*(DAY(H8)-DAY(G8)),DATEDIF(G8,H8,"Y")*50),0)其中G8是入职日期，H8是结算日期。
