天天微动态丨excel筛选年龄60岁以上人员名单_excel筛选年龄段公式

(相关资料图)

1、年龄计算：=DATEDIF(TEXT(MID(A2,7,8),"0000-00-00"),TODAY(),"Y")&"岁零"&DATEDIF(TEXT(MID(A2,7,8),"0000-00-00"),TODAY(),"YM")&"个月"&DATEDIF(TEXT(MID(A2,7,8),"0000-00-00"),TODAY(),"md")&"天"请点击输入图片描述满龄日期计算：=EDATE(TEXT(MID(A2,7,8),"0000-00-00"),12*IF(ISEVEN(MID(A2,17,1)),18,17))请点击输入图片描述距到期日：=IF(C2>TODAY(),"还差"&DATEDIF(TODAY(),C2,"Y")&"年零"&DATEDIF(TODAY(),C2,"YM")&"个月"&DATEDIF(TODAY(),C2,"md")&"天",IF(C2

本文到此分享完毕，希望对大家有所帮助。

关键词：