Date overdue...

Sorry this has probably been done to death in various guises but I can't quite pin down the correct formula to achieve the following.

I have a manual input date in cells E5:Exx
I have an automatic update by x months in G5:Gxx using
=DATE(YEAR(E5),MONTH(E5)+12, DAY(E5))

I also use a conditional format to flag when that date is overdue (red) using
=(NOW()>=(G5:G26))*AND(NOW()<=MAX(G5:G26))

What I can't seem to get is to flag when a date is due within x days, weeks or months

Any guidance appreciated - cheers

Figured it out, not pretty but works kind of using
=G5<=TODAY()+30

Would liked to have made it 2 stages to deadline i.e. at 14 days turn yellow but seems okay for now.

What would be nice though - VB anyone to accomplish the same steps?

If you have done one conditional format 2 are easy

1) =G5<=TODAY()+14 format yellow now press tthe add>> button

2) =G5<=TODAY()+30 format red

the order is important as the other way round anything that meets the second condition will meet the first condition so everything would be turned that colour

Regards

Dav