想要一個生日提醒對吧? =IF(AND(MONTH(A1)=MONTH(TODAY()),DAY(A1)=DAY(TODAY())),"今天過生日哦!",IF(AND(MONTH(A1)=MONTH(TODAY()),DAY(A1)+1=DAY(TODAY())),"只差一天過生日哦","")) excel到期提前兩周提醒
www.360doc.com