Dear Jim,
Please share your workbook
On Sat, Mar 10, 2012 at 6:13 AM, Jim wrote:
> I'm using Group by Day with 7 days to create the following example:
>
> 1/1/2012 - 1/7/2012
> 1/15/2012 - 1/21/2012
> 1/22/2012 - 1/28/2012
> 1/29/2012 - 2/4/2012
> 1/8/2012 - 1/14/2012<- out of order
> 2
Hi Jim,
Not sure exactly what your process is, but try following the steps here:
http://www.contextures.com/xlpivot07.html#Week
Asa
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Jim
Sent: Friday, March 09, 2012 4:44 PM
To: MS EX