15位、18位身份证混在一起求年龄的公式为
=IF(LEN(A1)>15,YEAR(NOW())-MID(A1,7,4),YEAR(NOW())-(MID(A1,7,2)+1900))+1
所以在右边空白列,如K1输入公式
=IF(and(IF(LEN(A1)>15,YEAR(NOW())-MID(A1,7,4),YEAR(NOW())-(MID(A1,7,2)+1900))+1>=60,IF(LEN(A1)>15,YEAR(NOW())-MID(A1,7,4),YEAR(NOW())-(MID(A1,7,2)+1900))+1<=80),"Yes","")
下拉即可标记出来
温馨提示:答案为网友推荐,仅供参考