Pivot Table Working Days Add

In the attached I have a multiple consolidation pivot table.

I have the data showing August and Sept data. I need to include all dates even if there is no data. I would also like to exclude weekends.

Currently I am only able to show the dates that have data.

Thanks.