Excel身份证相关函数

xiaoxiao2021-02-28 14

1 身份证计算年龄 =DATEDIF(TEXT(MID(A1,7,8),"#-00-00"),TODAY(),"Y") 2 身份证计算性别 =IF(MID(B3,17,1)/2=TRUNC(MID(B3,17,1)/2),"女","男")

转载请注明原文地址: https://www.6miu.com/read-2050269.html

技术

最新回复(0)