excel2007如何计算工龄?如A1中是入职时间1998.2.5,用什么公式计算出直至目前的工龄呢,计算整月即可

=datedif(substitute(A1,".","-"),today(),"y")&"年"&datedif(substitute(A1,".","-"),today(),"ym")&"个月"