Combining numeric and logical functions

[dprobst]

I have to calculate an expiration date in days and compare it to the current date. If the calculated days
is 0 or negative, I want to return a value of "Expired", otherwise I want it to return the actual days remaining.

I only know how to do this by adding a separate column. Is there a formula I can use to accomplish this without
having to add a second column for the logical function? I have attached a sample spreadsheet. Thanks.

DATE EXPIRATION DATE DAYS UNTIL EXPIRE STATUS
3/30/2015 3/29/2016 -1,513 EXPIRED
6/20/2019 6/19/2020 30
=A2+365 =B2-TODAY() =IF((C3<=0),"EXPIRED","")

If Days until Expire is 0 or negative, return "Expired", otherwise, return calculated days. Eliminate STATUS Column.

[etaf]

=b2-today() =if((c3<=0),"expired","")

=if((b2-today() < = 0),"expired",b2-today())

[dprobst]

This works perfectly. Thank you so much!

[etaf]

you are welcome