EXCEL 逆天功能之计算工龄会了你就无敌了

珍藏版!，如果你觉得不错，请分享给你的朋友们，独乐乐不如众乐乐！

同时也欢迎转载分享！

=DATEDIF(B2,TODAY(),"y")&"年"

=DATEDIF(B2,TODAY(),"y")&"年"&DATEDIF(B2,TODAY(),"ym")&"月"

=DATEDIF(B2,TODAY(),"y")&"年"&DATEDIF(B2,TODAY(),"ym")&"月"&DATEDIF(B2,TODAY(),"md")&"日"

注意：B列必须为日期格式