Auto Text insert based on IF & Conditional Formatting

I have two questions.
1st) I need column M to insert N/A if it doesn't meet the requirement. Column L is formatted with an IF based on contents in column E. Basically, if L = Not Required, then M should say N/A.

2nd) I would like the annual training column highlight red if it is within 30 days of Today, and Yellow if it is 31-60 days. I placed a conditional format for the 30 days, but my 60 doesn't seem to be working.

2 1/2) Is it possible to make a conditional format for the 1st day of the month Annual Training?

To help clarify, the Annual Training is the same as training due date. It is based on the trained date in Q.

I am learning so if someone notices I could have used a better formula or method, please educate me if you have the time.

I meant M2. let me check the CF formulas

Ahh, I think fixed it. I changed it to =IF($L:$L="Not Required","N/A","") is this correct? It seems to work.

Thank you AliGW, your advice worked. on the same sheet, how can I get Column P to appear blank if there is no date in Column Q?

I would ahve done that before, but i currently have in P2 =Q2+365
=[@[Date Trained]]+365

This is what is making it complicated for me.

Thank you for the advice, I changed all my formulas to row 2.

How am I able to get column P2 to calculate and show a blank if Q2 is blank. Right now it "P" shows 30-Dec-00 dates for all "Q" cells that are blank?

Than you very much for your superb informative responses. This conludes this post. I hope I do not run into any problems. I really need to practice nesting different functions, it is really confusing.