如何用函数计算工龄
的有关信息介绍如下：
计算公式=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
如何用函数计算工龄
Simone
发布于 2023-06-16 13:00:20
602 阅读
