COUNTIFS date from Column A > date in Column B

You can't do that with COUNTIFS, try SUMPRODUCT, something like this

=SUMPRODUCT((A$2:A$100>D1)*(A$2:A$100<D2)*(C$2:C$100="No")*(A$2:A$100>B$2:B$100))

where D1 and D2 define the date range