excel怎样找出退休人员
发布时间: 2023-08-23 12:07:48
‘壹’ 如何用EXCEL 选出达到退休年龄的人员
你要的公式:
=IF(IF(D2="女",55,60)-DATEDIF(TEXT(MID(B2,7,8),"0000-00-00"),TODAY(),"Y")<=0,"退休","")
热点内容
‘壹’ 如何用EXCEL 选出达到退休年龄的人员
你要的公式:
=IF(IF(D2="女",55,60)-DATEDIF(TEXT(MID(B2,7,8),"0000-00-00"),TODAY(),"Y")<=0,"退休","")