Maintenance Scheduling

[gooidn]

I am making a maintenance tracking spreadsheet. I need to be able to put a date in one cell and have another cell change based on that date. For example, I need to put in the date in cell "Last Performed" and have the "Due Date" shift based on an interval that I will enter for that situation, 30, 60, 90 days later etc. Then in the "Overdue" column, I need it to change color if the "Due Date" is within 30 days (Green) or 14 days (yellow). Then for the day it's due/past due, I want it to change to red. Thanks for all your help, I appreciate it

Last Performed	Due Date	Overdue
1-Jan-18

<tbody>
</tbody>

 

[Logit]

.

	A​	B​	C​	D​	F​	G​	H​	I​	J​	K​
1​	Last Performed​	Due Date​	Overdue​
2​	1-Nov-18​	1-Dec-18​
3​
4​				In B2 and copied down : =IF(A2="","",A2+30)
5​
6​				C2 … Conditional Formatting / Use a formula to determine which cells to format /
7​
8​				=$B2 < = TODAY ( ) + 30<today(())++30<today()+30<today()+30<today()+30<today()+30< td=""></today(())++30<today()+30<today()+30<today()+30<today()+30<>	<-- Format color GREEN
9​
10​				=$B2 < = TODAY ( ) + 14<today(())++14<today()+14<today()+14<today()+14<today()+14< td=""></today(())++14<today()+14<today()+14<today()+14<today()+14<>	<-- Format color YELLOW
11​
12​				=$B2<=TODAY()	<-- Format color RED
13​

<tbody>
</tbody>

The formulas in D8 and D10 should not have any spaces between the characters. I had to include spaces so the entire formula would display correctly. The Forum server does
not accept the use of HTML code ... of which some of the symbols are.