=IF(MOD(RIGHT(LEFT(G2,17)),2),男,女)