excel提醒函数设置VIP客户和员工生日前三天提醒

若贵公司需在员工生日当天赠送礼品，提醒购买需求促使你考虑在员工资料表中增设此类提示功能，此函数将助您实现。

1、 假如生日记录在B列，在另一列写入公式=IF(DATE(YEAR(TODAY()),MONTH(B2),DAY(B2))-TODAY()>=0,IF(DATE(YEAR(TODAY()),MONTH(B2),DAY(B2))-TODAY()=0,"今天生日",IF(DATE(YEAR(TODAY()),MONTH(B2),DAY(B2))-TODAY()=1,"明天生日",IF(DATE(YEAR(TODAY()),MONTH(B2),DAY(B2))-TODAY()=2,"后天生日",""))),"")

2、 也可以在B列使用条件格式：格式，条件格式，公式=IF(and（DATE(YEAR(TODAY()),MONTH(B2),DAY(B2))-TODAY()>=0,DATE(YEAR(TODAY()),MONTH(B2),DAY(B2))-TODAY()<3),TRUE,FALSE)设置格式颜色为红色，或别的颜色3生日一栏在X列在Y列输入下面公式=IF(AND(MONTH(X1)=MONTH(TODAY()),(DAY(X1)=DAY(TODAY()-3))),"即将生日",0)下拉出现“即将生日”说明再过三天他就生日啦