excel根据身份证号生成性别、出生日期、年龄

F68为身份证号码所在单元格

=IF(MOD(RIGHT(LEFT(F68,17),1),2),"男","女")
=YEAR(TODAY())-MID(F68,7,4)
=TEXT(MID(F68,7,8),"0000年00月00日")