=IF(A3="","",DATEDIF(TEXT((LEN(A3)=15)*19&MID(A3,7,6+(LEN(A3

来源：学生作业帮编辑：作业帮分类：综合作业时间：2024/05/13 19:46:02

=IF(A3="","",DATEDIF(TEXT((LEN(A3)=15)*19&MID(A3,7,6+(LEN(A3)=18)*2),"#-00-00"),TODAY(),"y"))
这个公式中如何实现到系统日期的上个月月底的年龄

=IF(A3="","",DATEDIF(TEXT((LEN(A3)=15)*19&MID(A3,7,6+(LEN(A3)=18)*2),"#-00-00"),TODAY()-DAY(TODAY()),"y"))
TODAY()换为TODAY()-DAY(TODAY())
也就是今天减去今天的号数,等于上月最后一天.

=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) IF(A3="","",A3), =IF(B2"",TEXT((LEN(B2)=15)*19&MID(B2,7,6+(LEN(B2)=18)*2),"#- =TEXT(--(19*(LEN(N4)=15)&MID(N4,7,6+(LEN(N4)=18)*2)),"####-# =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 在EXCEL函数中,=IF(LEN(B2)=15,19,"")&MID(B2,7,6+(LEN(B2)=18)*2) excel中身份号计算年龄 today 怎么改 =DATEDIF(TEXT(19*MOD(LEN(A1),2)&MID( 公式寻答=TEXT((LEN(A2)=15)*19&MID(A2,7,6+(LEN(A2)=18)*2),"0000-0