Question

excel DATEDIF(TODAY(),A1,"d")问题

我在B1里面设置公式：=DATEDIF(TODAY(),A1,"d")，让B1显示剩余的天数，但是这还没满足我的需求，我最终想要的是：当B1小于1时,B1就显示“已过期”，这个该怎么弄？

Answer 1

=IF(ISERROR(DATEDIF(TODAY(),A1,"d")),"已过期",IF(DATEDIF(TODAY(),A1,"d")=0,"今天过期","还有" & DATEDIF(TODAY(),A1,"d") & "天过期"))

Answer 2

=IF(DATEDIF(TODAY(),A1,"d")<1,"已过期",DATEDIF(TODAY(),A1,"d"))
参考公式

追问

还有个问题，
当今天时间已经超过A1的时间,就显示“#NUM”了，能不能让它还是显示"已过期"

追答

=IF(TODAY()>A1,"已过期",IF(DATEDIF(TODAY(),A1,"d")<1,"已过期",DATEDIF(TODAY(),A1,"d")))
请采纳

Answer 3

加个if函数在前面 =if(=DATEDIF(TODAY(),A1,"d")<1,"已过期",DATEDIF(TODAY(),A1,"d"))