VBA and Macros 2010 - "Group by Week": Podcast #1304

Today, in Episode #1304, Bill shows us how to use a Pivot Table in combination with Excel VBA [Visual Basic for Applications] to 'Roll-Up' dates to weekly increments.

By:=7, _
Periods:= Array(False, False, False, True, False, False, False)

From Chapter 13…This episode is the video podcast companion to the book, "VBA And Macros: Microsoft Excel 2010", from Bill Jelen a.k.a. MrExcel.

For all of your Microsoft Excel needs visit MrExcel.com - Your One Stop for Excel Tips and Solutions.

Tweet