For the weekday/weekend part I would do this:

Fully populate column A so that the date is on every row
Add this formula in H16 copied down

=TEXT(A16,"ddd")

Now you have a column with the weekday as text so you can use that in a SUMPRODUCT/SUMIFS function