Conditional Formatting Formula

Hi everyone,

I need some help using a formula to highlight cells. I have a spreadsheet with dates on it, and I want to make those dates highlight whenever the date is within 7 days. I've tried using a formula that someone told me would work using the
conditional formatting feature"AND(G3>TODAY(),G3<=(TODAY()+7)) but this randomly highlights cells. The dates that were highlighted were all over the place.

The dates were calculated using the EDate function. Ex: =EDATE(G3,E1) where the cell E1 contained the number 6, because I was calculating six months from a date in another cell. I don't know if that's relevant or not but thought I should mention it.

Can anyone recommend a solution?

I attached a screenshot of what the spreadsheet looks like.