2022-10-28
閱讀量:
2063
人事表格——生日到期提醒公式
=IF(DATE(YEAR(TODAY()),MONTH(F25),DAY(F25))-TODAY()>0,"還有"&DATE(YEAR(TODAY()),MONTH(F25),DAY(F25))-TODAY()&"天",IF(DATE(YEAR(TODAY()),MONTH(F25),DAY(F25))-TODAY()=0,"生日快樂(lè)","生日已過(guò)"))






評(píng)論(0)


暫無(wú)數(shù)據(jù)
CDA考試動(dòng)態(tài)
CDA報(bào)考指南
推薦帖子
0條評(píng)論
0條評(píng)論
0條評(píng)論