excel中身份号计算年龄 today 怎么改 =DATEDIF(TEXT(19*MOD(LEN(A1),2)&MID(
excel中身份号计算年龄 today 怎么改 =DATEDIF(TEXT(19*MOD(LEN(A1),2)&MID(
=DATEDIF(TEXT(MID(A1,7,INT(LEN(A1)/2-1)),"#-00-00"),"2010-12
=DATEDIF(TEXT(MID(F5,7,LEN(F5)/2-1),"0-00-00"),TODAY(),"Y")
=DATEDIF(TEXT(MID(A2,7,INT(LEN(A2)/2-1)),"#-00-00"),“2011-1-
比如:=TEXT((LEN(A1)=15)*19&MID(A1,7,6+(LEN(A1)=18)*2),"#-00-00
=IF(A3="","",DATEDIF(TEXT((LEN(A3)=15)*19&MID(A3,7,6+(LEN(A3
谁能给我详细的解释一下:DATEDIF(TEXT((LEN(M3)=15)*19&MID(M3,7,6+(LEN(M3)
在excel中YEAR(TODAY())-IF(LEN(C2)=15,"19"&MID(C2,7,2),MID(C2,7
=TEXT(--(19*(LEN(N4)=15)&MID(N4,7,6+(LEN(N4)=18)*2)),"####-#
=IF(MOD(MID(A1,15+(LEN(A1)=18)*2,1),2),"男","女")的解释
在EXCEL函数中,=IF(LEN(B2)=15,19,"")&MID(B2,7,6+(LEN(B2)=18)*2)
excel中没有datedif这个公式,在单元格输入公式=datedif(A1,TODAY(),"Y")结果返回错误值#