第1个回答 2011-01-11
如果R4里是合同起始日期的话,输入公式如下
=IF(R4="","",IF(TODAY()>R4,"合同已过期",IF(R4-TODAY()<16,IF(TODAY()-R4=0,"合同今日到期","合同还有"&(R4-TODAY())&"天到期"),"")))
我的公式是合同小于15天时提示“合同还多少天”,到期时会提示“合同已到期”,为空时则为空,
把你的公式变成这样
=IF(AND(A7<>"",(TODAY()-A7>=0)),"账号已到期","")
再简化一下
=IF(TODAY()-A7>=0,"账号已到期","")