1、从身份证号中提取生日,I3为EXCEL中存取身份证号码的单元格
=MID(I3,11,4)
2、提示当月生日,I3为EXCEL中存取身份证号码的单元格
=IF(MID(I3,11,2)=MID(TEXT(TODAY(),"yyyymmdd"),5,2),"本月生日"," ")
1、从身份证号中提取生日,I3为EXCEL中存取身份证号码的单元格
=MID(I3,11,4)
2、提示当月生日,I3为EXCEL中存取身份证号码的单元格
=IF(MID(I3,11,2)=MID(TEXT(TODAY(),"yyyymmdd"),5,2),"本月生日"," ")