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,"后天生日",""))),"")

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()))),"今日生日",""))))这个公式会在三天前开始提醒 “三天后生日”然后第二天提醒两天后生日一次类推到当日生日。然后出现空白