=DATEDIF(B2,"2013-12-1","y")下拉填充B列为入职日期，最好输入年月日，中间用-或/分隔
假设参加工作日期在A1，工龄公式：=IF(A1="","",2013-YEAR(A1)-(MONTH(A1)>11))
