dates weeks show week commencing

[exceliz]

Hi Need to set up a weekly report
it starts from 01/04/2011

so the first week goes 04/04/2011 - 10/04/11 in a pivot

i wanted to create down a column in a blank sheet showing:
WC 04/04/11
WC 11/04/11
WC 18/04/11 etc
and drag it all the way down to the 52nd week?

is it possible?
Thanks
Liz

 

[kidwispa]

If you head the column "Week Commencing" and then the column next to it "Week No" (for this example I'm assuming wc is in column A and Week No in B)

Input into column A

04/04/2011
11/04/2011

Input into column B

1
2

Highlight the selection (both in A & B) and drag down from the bottom right hand corner of the cell that contains the number 2 in column B...