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.

Hi,

Look if this one could be useful for you.

Originally Posted by den_1985

Hi,

Look if this one could be useful for you.

That looks pretty good. Is there an easy way to add in by Month and auto refresh on the pivot table?

Hi,

You have this option into the pivot options.

Originally Posted by den_1985

Hi,

Look if this one could be useful for you.

How can I update for October and November in the attached pivot?

Thanks.