Formula for if/then and dates

[jlajla24]

So I have a worksheet that has rows with specific customers

The columns of interest are Invoice date & years of maintenance contract purchased. The date is in day/month/year format and the years of maintenance is a whole number in years.

I need a formula to be able to tell me if the contract is expired. I'm imagining an if/then statement that says if the date invoiced + number of years (365) is < today, fill another cell with expired. Then my conditional formatting will color code the row based on the word expired filled in this new cell. The other true or false result would yield "current".

Hope I've explained this ok. You guys are always amazing so thanks in advance.

 

[Robertvk]

=IF(TODAY()<=(J17+(365*K17));"Active";"Expired")

or (if you work with comma's)

=IF(TODAY()<=(J17+(365*K17)),"Active","Expired")

Where J17 = invoice date
Where K17 = number of years of maintenance

 

[Gerald Higgins]

A slight variation, which would deal correctly with leap years, would be

=if((date(year(a1)+a2,month(a1),day(a1))< today(),"Expired","Current")

which assumes date invoiced is held in A1, and years of maintenance is in a2.

 

[jlajla24]

Nailed it. THANKS!!!!