DATEDIF(TEXT(MID(O5,7,8),"0000-00-00"),TODAY(),"y")

DATEDIF(TEXT(MID(O5,7,8),"0000-00-00"),TODAY(),"y") =DATEDIF(TEXT(MID(F5,7,LEN(F5)/2-1),"0-00-00"),TODAY(),"Y") =DATEDIF(TEXT(MID(A1,7,INT(LEN(A1)/2-1)),"#-00-00"),"2010-12 =DATEDIF(TEXT(MID(A2,7,INT(LEN(A2)/2-1)),"#-00-00"),“2011-1- =DATEDIF(TEXT(A1,"0-00-00"),TODAY(),"y")这个函数怎么解读,"0-00-00"是怎 excel中身份号计算年龄 today 怎么改 =DATEDIF(TEXT(19*MOD(LEN(A1),2)&MID( TEXT(SUM(DATEDIF(A1,NOW(),{"y","ym","md"})*10^{4,2,0}),"0年00 TEXT(SUM(DATEDIF(A1,TODAY(),{"Y","YM","MD"})*10^{4,2,0}),"0年 请解释以下函数 =TEXT(SUM(DATEDIF(G2,TODAY(),{"Y","YM"})*10^{2,0})," 谁能给我详细的解释一下：DATEDIF(TEXT((LEN(M3)=15)*19&MID(M3,7,6+(LEN(M3) =IF(A3="","",DATEDIF(TEXT((LEN(A3)=15)*19&MID(A3,7,6+(LEN(A3 =DATEDIF(TEXT(SUBSTITUTE(2007.10,".","-"),"yyyy-mm"),TODAY()