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.
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.
Last edited: