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


[TABLE="width: 308"]
<tbody>[TR]
[TD]Last Performed[/TD]
[TD]Due Date[/TD]
[TD]Overdue[/TD]
[/TR]
[TR]
[TD]1-Jan-18[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Logit]

.


[TABLE="class: head"]
<tbody>[TR="bgcolor: #888888"]
[TH][/TH]
[TH]

A​

[/TH]
[TH]

B​

[/TH]
[TH]

C​

[/TH]
[TH]

D​

[/TH]
[TH]

F​

[/TH]
[TH]

G​

[/TH]
[TH]

H​

[/TH]
[TH]

I​

[/TH]
[TH]

J​

[/TH]
[TH]

K​

[/TH]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

1​

[/TD]
[TD]

Last Performed​

[/TD]
[TD]

Due Date​

[/TD]
[TD]

Overdue​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

2​

[/TD]
[TD]

1-Nov-18​

[/TD]
[TD]

1-Dec-18​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

3​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

4​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]In B2 and copied down : =IF(A2="","",A2+30)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

5​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

6​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C2 … Conditional Formatting / Use a formula to determine which cells to format /[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

7​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

8​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]=$B2 < = TODAY ( ) + 30<today(())++30<today()+30<today()+30<today()+30<today()+30< td=""></today(())++30<today()+30<today()+30<today()+30<today()+30<>[/TD]
[TD]<-- Format color GREEN[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

9​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

10​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]=$B2 < = TODAY ( ) + 14<today(())++14<today()+14<today()+14<today()+14<today()+14< td=""></today(())++14<today()+14<today()+14<today()+14<today()+14<>[/TD]
[TD]<-- Format color YELLOW[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

11​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

12​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]=$B2<=TODAY()[/TD]
[TD]<-- Format color RED[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: #FFFFFF"]
[TD="bgcolor: #888888"]

13​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


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.