(完整版)身份证号码提取年龄出生年月公式,excel 筛选相同数据或不同数据公式
性别:
=IF(ISBLANK(C3)," ”,IF(C3〈>”",IF(MOD(RIGHT(LEFT(C3,17)),2),"男",”女"),))
出生日期:
=IF(ISBLANK(C3)," ",IF(LEN(C3)=18,MID(C3,7,4)&"—"&MID(C3,11,2)&"—"&MID(C3,
13,2),”19"&MID(C3,7,2)&”—"&MID(C3,9,2)&"—"&MID(C3,11,2)))
年龄:
=DATEDIF(TEXT(MID(C3,7,8),”#—00-00”),TODAY(),"y”)
筛选相同数据公式
=IF(COUNTIF(Sheet1!$B$1:$B$232,B232),"S”,”F”)
评论0
最新资源