EXCEL2003中如何按月计算工龄工资 - 知识问答

=14,b1+100*datedif(a1,today()," property="og:description"/> EXCEL2003中如何按月计算工龄工资 - 知识问答 =14,b1+100*datedif(a1,today(),"/>

EXCEL2003中如何按月计算工龄工资

2个回答

如果入职时间为a1,基本共资为b1
=if(datedif(a1,today(),"m")>=14,b1+100*datedif(a1,today(),"y"),b1)

相关问题