2022-10-28
閱讀量:
2003
人事表格——生日到期提醒公式
=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,"生日快樂","生日已過"))






評論(0)


暫無數(shù)據(jù)
推薦帖子
0條評論