Have an excel file that tracks daily dates against a daily metric.
What I'd like to do is convert the table into weekly metrics. Is there an easy way to do this, perhaps with pivot tables?
Have an excel file that tracks daily dates against a daily metric. What I'd like to do is convert the table into weekly metrics. Is there an easy way to do this, perhaps with pivot tables? 


Here's one way to do it using a helper column for Weeks, populating it with a formula to get the week, then pivoting by week (this works in Excel 2007  I presume it would in 2010, as well).
And, to elaborate on the comments below, here's how to do it from within the pivot table itself without a helper column:
To undo this, right click on any of the dates in the pivot table, and select 'Ungroup.' 


The pivot table can also be built without a helper column. Group the dates by days and set them at 7 day intervals. 

