如何用函数计算工龄

如何用函数计算工龄

计算公式=DATEDIF(A55,TODAY(),"y")&"年"&DATEDIF(A55,TODAY(),"ym")&"月"&DATEDIF(A55,TODAY(),"md")&"日" (a55是你入厂日期），年龄直接现在日期减去生日即可得到工龄另外虚岁的计算：=YEAR(TODAY())-YEAR(A1)实岁的计算：=-TRUNC((A1-TODAY())/365)工龄的计算：=（YEAR(TODAY())-YEAR(A1)）+1

标签：工龄,函数,计算