Traffic Lights formula in excel

[Libdoc]

Hello,

I'm tearing my hair out slightly over this so would appreciate any help!

I have a list of documents in a spreadsheet and part of this includes a column (P) that has review dates. The dates are as follows:

01/02/2019
01/04/2020
01/11/2018

I've been asked to create a traffic light format for the dates e.g. in date GREEN, within 6 months AMBER and after six months (out of date) RED.

Now I can set up traffic lights using the conditional format- use a formula to determine which cells to format but the control date is TODAY (as in 12/12/2018).

What I need to do is somehow use the dates in the cells as the control dates e.g. so that six months before 01/04/2020 expires it turns amber.

Is there a way to do this?

[Glenn Kennedy]

Is this what you want?

=EDATE(TODAY(),6)>A2

and

=TODAY()>A2

[Glenn Kennedy]

I forgit the green:

=EDATE(TODAY(),6)<=A3