Countifs comparing dates in same table

[jdanilog]

Hi everyone,
It is my first time using this service so hoping I will find the answer I need...

I got this table named TableTimeData:

OPP Number [Project: Created Date] [Site Visit - Completed Date]
0001 11/01/2018 03/15/2019
0002 12/01/2018 03/31/2019
0003 03/01/2019 03/15/2019

In another sheet called INPUT I got this cells with the following values:

G7 I7 Q7
03/01/2019 03/31/2019 20

What I need is to count all rows in table TableTimeData that has the Site Visit Completed Date (Site Visit - Completed Date) within this dates 03/01/2019 and 03/31/2019 and has been site visited (Site Visit - Completed Date) a day NOT more than 20 days after the creation (Project: Created Date).

I wrote the following formula but it seem that the last criteria (in red) has something wrong:

=COUNTIFS(TableTimeData[Site Visit - Completed Date],">="&INPUT!$G$7,TableTimeData[Site Visit - Completed Date],"<="&INPUT!$I$7,TableTimeData[Project: Created Date],">="&TableTimeData[Site Visit - Completed Date]-$Q$7)

The expected result must be 2.

 

[DanteAmor]

Try this

=SUMAPRODUCTO((TableTimeData[Site Visit - Completed Date]>=G7)*(TableTimeData[Site Visit - Completed Date]<=I7)*(TableTimeData[Site Visit - Completed Date]-TableTimeData[Project: Created Date]>20)*1)