Calculating weekly totals by dates from a pivot table

[Craig_Foggo]

Hi All

I have a pivot table that I refresh daily/weekly so I can record works completed.

I would like to have a view of what works have been carried out on a week by week basis

i.e Cell F3 has a calculation of what works have been carried out for the week 6-12th May, Cell G3 has a calculation of what works have been carried out for the week 13-19th May

The field these cell take the information from is from the Pivot Table sheet Column N which is the date the task was completed

Hope this all makes sense.

Thanks in Advance

Craig

[fredfarmer]

Hi Craig,

If you could attach a sample file it would help.

Thanks,
FF