直接上干货
=IF(DATEDIF(A2,TODAY(),"y")>0,DATEDIF(A2,TODAY(),"y")&"年","")&IF(DATEDIF(A2,TODAY(),"ym")>0,DATEDIF(A2,TODAY(),"ym")&"个月","")
其中 A2 是入职日期的单元格,
直接上干货
=IF(DATEDIF(A2,TODAY(),"y")>0,DATEDIF(A2,TODAY(),"y")&"年","")&IF(DATEDIF(A2,TODAY(),"ym")>0,DATEDIF(A2,TODAY(),"ym")&"个月","")
其中 A2 是入职日期的单元格,