=DATE(YEAR(CONCATENATE(MID(C1,7,VLOOKUP(LEN(C1),{15,2;18,4},2,0)),"/",MID(C1,VLOOKUP(LEN(C1),{15,9;18,11},2,0),2),"/",MID(C1,VLOOKUP(LEN(C1),{15,11;18,13},2,0),2))),MONTH(CONCATENATE(MID(C1,7,VLOOKUP(LEN(C1),{15,2;18,4},2,0)),"/",MID(C1,VLOOKUP(LEN(C1),{15,9;18,11},2,0),2),"/",MID(C1,VLOOKUP(LEN(C1),{15,11;18,13},2,0),2))),DAY(CONCATENATE(MID(C1,7,VLOOKUP(LEN(C1),{15,2;18,4},2,0)),"/",MID(C1,VLOOKUP(LEN(C1),{15,9;18,11},2,0),2),"/",MID(C1,VLOOKUP(LEN(C1),{15,11;18,13},2,0),2))))
看看这个公式还能不能简?^-^
生日:
=DATE(MID(A2,7,4),MID(A2,11,2),MID(A2,13,2))
合法性:
=IF(LEN(A2)<>18,"不合法","合法")
见附件。