出生日期: TEXT(MID(C2,7,8),"00-00-00") 年龄: =DATEDIF(TEXT(MID(C2,7,8),"00-00-00"),TODAY(),"y") 转载于:https://www.cnblogs.com/wenlong2019/p/11418721.html