Countifs or Sumproduct multiple criteria’s between two dates

[Plukey]

I'm currently using this formula to count the assurances that matches a name from column "J" and a Yes from "C" now I need it between two dates that are in "I"
The data is on another sheet.

=COUNTIFS(Table1[Name],"*"&HOME!C12&"*",Table1[INDIRECT],"Yes")

 

[Plukey]

I figured it out>…..

=COUNTIFS(Table1[COMPLETION DATE],">"&$G$9,Table1[COMPLETION DATE],"<"&$H$9,Table1[Name],"*"&HOME!C12&"*",Table1[yes/no],"Yes")