b2往下放入职日期（日期格式有年月日就行）
c2用公式求出工作年限
c2==IF(MONTH(TODAY())>MONTH(B2),(YEAR(TODAY())-YEAR(B2)) & "年" & MONTH(TODAY())-MONTH(B2) & "月",(YEAR(TODAY())-YEAR(B2)-1) & "年" & MONTH(TODAY())-MONTH(B2)+12 & "月")
543
513
360
342
314
313
312
307
306
306
2023-12-23 17:45
admin