如何使用同一个函数公式计算离职员工及在职员工的司龄

Question

如题所述

Answer 1

=DATEDIF(C2,IF(E2,E2,TODAY()),"Y")&"年"&DATEDIF(C2,IF(E2,E2,TODAY()),"Ym")&"月"&DATEDIF(C2,IF(E2,E2,TODAY()),"mD")&"天"