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

1、假如生日记录在B谱驸扌溺列，在另一列写入公式=IF(DATE(YEAR(TODAY()),MONTH(B2),DAY(B2))-TODAY()>=0,IF(DATE(YEAR(T晦倘佳鳎ODAY()),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)下拉出现“即将生日”说明再过三天他就生日啦

4、或者下面这个功熹栳缂靖能全面一些：=IF(AND(MONTH(X2)=MONTH(TODAY()),(DAY(X2)=DAY(TODAY()-3))),"三日后生日",IF(A绿覆冗猩ND(MONTH(X2)=MONTH(TODAY()),(DAY(X2)=DAY(TODAY()-2))),"两日后生日",IF(AND(MONTH(X2)=MONTH(TODAY()),(DAY(X2)=DAY(TODAY()-1))),"明天生日",IF(AND(MONTH(X2)=MONTH(TODAY()),(DAY(X2)=DAY(TODAY()))),"今日生日",""))))这个公式会在三天前开始提醒 “三天后生日”然后第二天提醒两天后生日一次类推到当日生日。然后出现空白