1. 分步image.png
    2. 合成写image.png

    公式:=IF(OR(AND(IF(MOD(MID(A508,17,1),2)=1,”男”,”女”)=”女”,AND(DATEDIF(—TEXT(MID(A508,7,8),”0000-00-00”),TODAY(),”y”)>18,DATEDIF(—TEXT(MID(A508,7,8),”0000-00-00”),TODAY(),”y”)<55)),AND(IF(MOD(MID(A508,17,1),2)=1,"男","女")="男",AND(DATEDIF(--TEXT(MID(A508,7,8),"0000-00-00"),TODAY(),"y")>18,DATEDIF(—TEXT(MID(A508,7,8),”0000-00-00”),TODAY(),”y”)<60))),”符合”,”不符合”)