excel 时间提示 我现在有的excel2007,我想做个表格,来提示到期...

发布网友 发布时间：2024-10-23 22:41

我来回答

共2个回答

热心网友 时间：2024-11-09 18:51

假定你的生日1986-01-01输入在A1，在其它任意单元格输入公式：
=IF(AND(MONTH(A1)=MONTH(TODAY()),DAY(A1)=DAY(TODAY())),"祝你生日快乐！",IF(AND(MONTH(A1)=MONTH(TODAY())+1,AND(DAY(EOMONTH(NOW(),0))+DAY(A1)-DAY(TODAY())<=15,DAY(A1)-DAY(TODAY())<=-1)),"还有 "&DAY(EOMONTH(NOW(),0))+DAY(A1)-DAY(TODAY())&" 天过生日 ^_^",IF(AND(MONTH(A1)=MONTH(TODAY()),AND(DAY(A1)-DAY(TODAY())<=15,DAY(A1)-DAY(TODAY())>=1)),"还有 "&DAY(A1)-DAY(TODAY())&" 天过生日 ^_^","")))

当你生日前15天开始，每天倒计时提醒，直到生日那天。其余时都为空。

热心网友 时间：2024-11-09 18:54

假如出生日期在D列，该职工生日在D2，在E2输入=IF(AND(DATE(YEAR(TODAY()),MONTH(D2),DAY(D2))-TODAY()>=0,DATE(YEAR(TODAY()),MONTH(D2),DAY(D2))-TODAY()<=15),"员工半月内过生日","")
回车即显示员工半月内过生日，下拉公式即其他职工的生日到时也会显示