1-1.=IF(LEN(A4)=15,TEXT(MID(A4,7,6),"1900-00-00"),TEXT(MID(A4,7,8),"0000-00-00"))
1-2.=IF(LEN(A4)=15,IF(MOD(MID(A4,15,1),2),"男","女"),IF(MOD(MID(A4,17,1),2),"男","女"))
2-1.=TEXT(B12,"公元yyyy年mm月d日")
2-2.=TEXT(B12,"d-mm-yyyy")
2-3.=TEXT(B12,"yyyy年mm月d日[$-804]aaaa;@")
3.=MID(A8,FIND("#",SUBSTITUTE(A8,"-","#",3))+1,FIND("#",SUBSTITUTE(A8,"-","#",4))-FIND("#",SUBSTITUTE(A8,"-","#",3))-1)
4.=SUM(RIGHT(LARGE(IF(ISNUMBER(--MID(A10,ROW($1:$20),1)),MID(A10,ROW($1:$20),1)+ROW($1:$20)*100,0),ROW($1:$20)),1)*10^(ROW($1:$20)-1))
5.=IF(TEXT(INDEX($G$7:$G$17,MATCH(MOD(SUM(MID(A8,ROW($1:$17),1)*$D$7:$D$23),11),$F$7:$F$17,0)),"@")=RIGHT(A8,1),"真","假")
|