Pivot table + date filters + networkdays()?

Question

I set up a quick PivotTable with my team's time entry data (date, hours entered against billable and internal charge codes, etc.).

I also added a filter for "Week Number" so I could check utilization for certain weeks. I'd like to pivot table to display the # of work days (and/or work hours) - is there such a feature?

Otherwise, I was playing around with the idea of simply creating a formula that would calculate the start and end date based on the week number selected:

Which works fine, except if I select multiple values (i.e. week number 6 and 7), then it outputs "Multiple Items" and the equation will not work with that (and I don't know how to get around that).

Answer 1

Hi,

Since your query is related to Pivot tables, you may also post this in the following TechNet forum for better suggestions.

http://social.technet.microsoft.com/Forums/en/excel/threads

If you have any other question, feel free to ask.

Thank you.