请高手设计个EXCEL日期函数

来源：百度知道编辑：UC知道时间：2024/06/30 16:35:09

设定单元格1为2009-3-16 ，在单元格2设定个函数，使系统日期超过此日期时显示“已到期”，当系统日期与此日期差1-30天时，单元格2显示“即将到期”。谢谢！

假设你的日期在a1，提醒放在b1，则
b1=if(a1>today(),"已到期"，if(a1-today<=30,"即将到期"))

日期输入到A1
A2=IF(TODAY()>A1,"已到期","即将到期")

=if(TODAY()>A1,"已到期",IF(and(today()-a1>-31,today()-a1<0),"即将到期",""))

A2=IF(TODAY()-A1<1,"已到期",IF(AND(TODAY()-A1>0,TODAY()-A1<31),"即将到期",""))

=IF(TODAY()>=A1,"已到期",IF(AND(TODAY()<A1,A1-TODAY()<30),"即将到期",""))