I need to create a count if cola and colb meet a certain criteria. Example:

A B
6-Jul dog
13-Jul dog
6-Jul cat
6-Jul dog
13-Jul dog
13-Jul dog
13-Jul cat
13-Jul dog

The count would be 2 as I am looking for dogs on July 6. The hiccup is the
date. I need it to calculate the WEEKNUM as a separate entity for each
weekending. The output should look something like this.

W/E count dog count cat
6-Jul 2 1
13-Jul 4 1

I currently have this:

=SUMPRODUCT((A2:A5001=39970)*(E2:E5001="dog"))

But I have to go in and generate a new formula for each weekending, and I
need to avoid that.

Many thanks for any help.

Regards