第1个回答 2011-12-28
假设身份证号在A1,B1=datedif(date(mid(A1,7,4),mid(A1,11,2),mid(A1,13,2),today(),"y")
显示周岁
第2个回答 2011-12-29
=IF(LEN(A1)=18,DATEDIF(DATE(MID(A1,7,4),MID(A1,11,2),MID(A1,13,2)),TODAY(),"d")/365,DATEDIF(DATE(19&MID(A1,7,2),MID(A1,9,2),MID(A1,11,2)),TODAY(),"d")/365))
另选中A列,在数据有效性设置里,选择自定义:=or(len(A1)=18,Len(A1)=15)
或
输入:=IF(LEN(A1)=18,DATEDIF(DATE(MID(A1,7,4),MID(A1,11,2),MID(A1,13,2)),TODAY(),"d")/365,IF(LEN(A1)=15,DATEDIF(DATE(19&MID(A1,7,2),MID(A1,9,2),MID(A1,11,2)),TODAY(),"d")/365,"您输入的身份证号码有错误"))