RAG Status using conditional format for 3 dates

[Ravi_j27]

Hi

I have a set of dates in A1, which are planned dates to complete works. I would like the cells in column B to highlight according to a RAG status.

If the Dates in Column A1 is within 7days of Today(), the cell highlights red.
If the Dates in Column A1 is within 7-21days of Today(), the cell highlights Amber.
If the Dates in Column A1 is within 28days of Today(), the cell highlights Green.
If the Dates in Column A1 is 28 days after Today() the cell highlights Blank.

I have searched various threads and tried various equations but no luck, please help

rav

 

[Ravi_j27]

Apologies I meant a set of dates in column A, not just column A1.