Date Function

[Xirom431]

Hi,

Is there a function where I can rage down to display the first day of 52 weeks in a year in one column? Thanks for the help. Excel 2010

Example

Week Of

1 January 02, 2012
2 January 09, 2012
3 January 16, 2012 and so on.

 

[VoG]

In A1 enter 2 January 2011

in A2 enter

=A1+7

and copy down.

 

[Andrew Poulsom]

Enter the first 2 dates as dates and drag down. Then format them as mmmm dd, yyyy.