Conditional Format afer 14 Days

Hi All,

I Have the below formula that I have put in the Conditional Formatting which works fine but, I want this Conditional Formatting Formula to take effect when it is 14 days + from date in P7, this conditional format is in Q7, once a date is then entered into Q7 it goes back to white again.

=AND(ISNUMBER($G6),ISNUMBER($P6),$R6="")

Can anyone help please.

Shazz
xx

you can try this

=IF((P7+14)>TODAY(),AND(ISNUMBER($G6),ISNUMBER($P6),$R6=""),"")

only modification is =IF((P7+14)>TODAY(),"value if true (your formula)", Otherwise "")

thank,s
A