Temporary fix which is better than anything else.

=COUNT(IF(H:H=T36, IF(H:H<=T37, COUNTIF(D:D, "Name"))))

Only disadvantage here is that the dates were defined in different columns,
hence the reference to T36 and T37.

For programmers this could be a real hassle especially if youre trying to define every single date parameter.