excel表格里面怎么计算工作年限?怎么输入公式?答:设B2为入职日期,C2为到期日期,则工龄为:=datedif(B2,C2,"Y")如果计算到今天,则 =datedif(B2,NOW(),"Y")如果要准确到年月日,可用如下公式:=DATEDIF(B2,C2,"Y")&"岁"&DATEDIF(B2,C2,"YM")&"个月零"&DATEDIF(B2,C2,"MD")&"天"或 =DATEDIF(B2,NOW(),"Y")&"岁"&DATEDIF(...
日期格式为2013.12的excel计算工作年限,精确到年月,不满一年显示几个...答:M5公式:=DATEDIF(SUBSTITUTE(L5,".","-"),TODAY(),"y")&"年"&DATEDIF(SUBSTITUTE(L5,".","-"),TODAY(),"ym")&"个月"