Conditional Formatting or formula for comparing dates

I am looking for the best way to do this. I have a spreadsheet where a date something is received is entered in column A and the date it goes back out is in column G. I need to have the cell in G turn green if the date entered is within 7 days of the date in column A and turn red if it is 8 days or later. (hope that all makes sense)

I have tried browsing through multiple thread and can't seem to get it right. Can anyone please help?

I have tried browsing through multiple thread and can't seem to get it right.

I think you didn't search very well, this kind of topic has been asked a zillion times ! ( give or take a few millions)

Select col G and enter

Please Login or Register  to view this content.

You're welcome