提取出生年月 =TEXT(MID(B2,7,8),"00-00-00") 提取年龄 =DATEDIF(TEXT(MID(B2,7,8),"00-00-00"),TODAY(),"y") 提取性别 =IF(MOD(MID(C2,17,1),2),"男","女")