我测试过了，好用！！希望采纳哟~比方说a1是身份证号码，则在a2输入公式：=if(value(year(today()))-value(mid(a2,7,4))>=60,"60以上",value(year(today()))-value(mid(a2,7,4)))
