How to get conditional formatting to use the cell date value?

I set up conditional formatting with the goal of checking cell dates. The formatting is supposed to gauge and show how quickly a date is coming up to complete a task.

Below is how I set this up. What I did was use TODAY() thinking that would pull the cell value. What it is doing is using the current date instead of the cell date. How do I use the cell's date instead? If the cell value of I12 is 6/3, how does that compare to today? Are we x days before or after?

You can see from the green outlined cells a specific date and then the other green outline represents the date ranges I am after. The 6/3/2021 date should not have any highlighting at all since the date passed.

Any ideas?

UPDATE

Solution 1:

If it is compared with the date in the cell, determine whether today is before or after it, please try the following formulas.

[37-21] days before: =AND(A2-TODAY()>=21,A2-TODAY())<=37

[20-8] days before: =AND(A2-TODAY()>=8,A2-TODAY()<=20)

[7-0] days before: =AND(A2-TODAY()>=0,A2-TODAY()<=7)

(0-7] days after: =AND(A2-TODAY()>=-7,A2-TODAY()<0)