A06:coolppt
出生日期- =IF(LEN(A2)=15,TEXT(19&MID(A2,7,6),"0-00-00"),TEXT(MID(A2,7,8),"0-00-00"))
复制代码- =TEXT(IF(LEN(A2)=18,MID(A2,7,8),19&MID(A2,7,6)),"0-00-00")
复制代码- =IF(LEN(A2)=18,TEXT(MID(A2,7,8),"0-00-00"),TEXT(MID(A2,7,6),"1900-00-00"))
复制代码- =IF(LEN(A2)=18,TEXT(MID(A2,7,6+2*(LEN(A2)=18)),"0-00-00"),TEXT(MID(A2,7,6+2*(LEN(A2)=18)),"1900-00-00"))
复制代码- =IF(LEN(A2)=18,TEXT(MID(A2,7,LEN(A2)/2.25),"0-00-00"),TEXT(MID(A2,7,LEN(A2)/2.25),"1900-00-00"))
复制代码- =TEXT(RIGHT(TEXT((0&MID(A2,7,11))-500,"1900-00-00,;!0"),10),"e-mm-dd;;;错误")
复制代码- =TEXT(TEXT(MID(A2,7,6+(LEN(A2)=18)*2),"0-00-00")+0,"YYYY-MM-DD")
复制代码- =TEXT(TEXT((0&MID(A2,7,11))-500,"00-00-00,;!0"),"e-mm-dd;;;错误")
复制代码- =TEXT(TEXT(MID(A2,7,11)-500,"0-00-00,"),"YYYY-MM-DD")
复制代码 性别- =IF(LEN(A2)=18,IF(MOD(MID(A2,17,1),2),"男","女"),IF(MOD(MID(A2,15,1),2),"男","女"))
复制代码- =IF(MOD(MID(A2,15,3),2),"男","女")
复制代码- =IF(ISODD(MID(A2,15,3)), "男","女")
复制代码- =IF(ISEVEN(MID(A2,15,3)),"女", "男")
复制代码- =MID("女男",ISODD(MID(A2,15,3))+1,1)
复制代码- =MID("女男",MOD(MID(A2,15,3),2)+1,1)
复制代码 |