如何利用excel自动计算在职时间，求高人指导，在线等
发布网友
共3个回答
热心网友
按年=TEXT(DATEDIF(K3,L3,"D"),"yy年mm个月")
按月=TEXT(DATEDIF(K3,L3,"D"),"mm个月")
按日=TEXT(DATEDIF(K3,L3,"D"),"dd天")
热心网友
在按年填上：=CONCATENATE(DATEDIF(K3,L3,"y"),"年",DATEDIF(K3,L3,"ym"),"个月",)
按月：=CONCATENATE(DATEDIF(K3,L3,"m"),"个月")
按天：=CONCATENATE(DATEDIF(K3,L3,"d"),"天")
热心网友
把函数改成离职时间单元格减去入职时间单元格，请采纳谢谢
