Count how many cells < > value X provided they match other criteria first - ( How many "OPEN" "IT" "RISKS" are due for action with "X" days of today

[NGADAMS]

Scenario
1: I need to count the number of Items (Risks) in Total
2: I need to count the number of Items (Risks) Open or Closed
3: I need to count the number of Items (Risks) Open and due for Action within X days of today

Problem
I am stuck at requirement 3 - effectively "how many open IT risks are due for action with x days of today"

Current Setup
I have an XL Sheet "Data" which holds a register of risks and issues
All calcs and todays date are captured on a sheet called "Status"

Here is how I calculate the elements of the Status Sheet

Number of IT RISKs is calculated by: =COUNTIFS(Data!D:D,B7,Data!$E:$E,$C$6)

Where:
Data!D:D is a Column of "Prog Stream" names
B7 = Stream name to match (IT)

Data!E:E is Column of "Risk" or "Issue"
$C$6 = RISK

Number of OPEN IT Risks is calculated by: =COUNTIFS(Data!$D:$D,$B7,Data!$E:$E,$C$6,Data!$T:$T,$E$6)
Where:
Data!D:D is a Column of Stream names
B7 = Stream name to match

Data!E:E is Column of "Risk" or "Issue"
$C$6 = RISK

Data!T:T is column of "OPEN" or "CLOSED"
$E$6 = OPEN

Request for assistance
How can I calc: The number of the Open risks which are due within 7, 14, 30 or greater than 30 days

I tried :=COUNTIFS(Data!$D:$D,$B7,Data!$Q:$Q,(($B$3-Data!$Q:$Q)<M$14))
Where

Data!D:D is a Column of Stream names
$B7 = Stream name to match
$B$ = today()

Data!$Q$Q = Column of "Action by Dates" on "Data! sheet"

<M$14 7)
Thanks for help
Obviously I am doing something wrong but can not see the wood for the trees

All (any) advice gratefully received

Kind regards
Nom