Using INT(NOW()) I want my logical test in excel to have an answer of three values?

Question

example:

Date Issued is June 20, 2008

Expiration Date is June 20, 2013

if date is June 20, 2013 using (int(NOW()) value is EXPIRED

Date Issued is June 20, 2008

Renewal Date is June 20, 2012

if date is June 20, 2012 using (int(NOW()) value is RENEW

Date Issued is June 20, 2008

Present date up to June 19, 2012 before renewal

using (int(NOW()) value is ACTIVE

Answer 1

Then I suggest you not ask in Cars and Transportation, Insurance and Registration.