Conditional format query on date formula2

[BrutalLogiC]

Hi, I have a column of dates and I want a formula that looks at these dates and highlights any that are within 3 years

e.g.
cell P15 = 31/01/05 this would not be highlighted
cell P16 = 31/01/16 this would not be highlighted
cell P17 = 14/10/12 this would be highlighted
cell P18 = "to book" this would not be highlighted

I also need a formula that looks at a column and highlights any dates. Is this possible?

 

[oldbrewer]

if A1 is a date and G1 = today's date

if(G1-A1<1095, highlight, do not highlight)

look at isdate function

 

[BrutalLogiC]

if A1 is a date and G1 = today's date

if(G1-A1<1095, highlight, do not highlight)

look at isdate function

is this to use with conditional formatting? I want the cell to be highlighted background green when the date falls within 3 years of today's date.

 

[oldbrewer]

for conditional formatting

highlight A1 then format, conditional formatting

formula is

=g1-a1 < 1095

and set patterns = green