求出生年月日我建议公式IF=DATE(MID(AG77,7,2+INT(LEN(AG77)/16)*2),MID(AG77,9+INT(LEN(AG77)/16)*2,2),MID(AG77,11+INT(LEN(AG77)/16)*2,2))
求年年龄我建议公式IF=DATEDIF(DATE(MID(AG78,7,4),MID(AG78,11,2),MID(AG78,13,2)),TODAY(),"y")
求服务年限我建议公式IF=IF((DATEDIF(AC78,NOW(),"ym")>0)+(DATEDIF(AC78,NOW(),"y")>0),"满"&IF(DATEDIF(AC78,NOW(),"y")>0,DATEDIF(AC78,NOW(),"y")&"年","")&IF(DATEDIF(AC78,NOW(),"ym")>0,DATEDIF(AC78,NOW(),"ym")&"个月",""),"未满一个月")
求员工性别我建议公式=IF(MOD(MID(AG78,17,1),2)=1,"男","女")
其他的学习了。