天天微動(dòng)態(tài)丨excel篩選年齡60歲以上人員名單_excel篩選年齡段公式

互聯(lián)網(wǎng)
2023-05-08 21:48:49

(相關(guān)資料圖)

1、年齡計(jì)算：=DATEDIF(TEXT(MID(A2,7,8),"0000-00-00"),TODAY(),"Y")&"歲零"&DATEDIF(TEXT(MID(A2,7,8),"0000-00-00"),TODAY(),"YM")&"個(gè)月"&DATEDIF(TEXT(MID(A2,7,8),"0000-00-00"),TODAY(),"md")&"天"請(qǐng)點(diǎn)擊輸入圖片描述滿齡日期計(jì)算：=EDATE(TEXT(MID(A2,7,8),"0000-00-00"),12*IF(ISEVEN(MID(A2,17,1)),18,17))請(qǐng)點(diǎn)擊輸入圖片描述距到期日：=IF(C2>TODAY(),"還差"&DATEDIF(TODAY(),C2,"Y")&"年零"&DATEDIF(TODAY(),C2,"YM")&"個(gè)月"&DATEDIF(TODAY(),C2,"md")&"天",IF(C2

本文到此分享完畢，希望對(duì)大家有所幫助。

關(guān)鍵詞：

分享到:

一鍵登錄