Date Range
 

I'm new to Excel (2003), so . . .
I'm trying to make a column to show every Sunday of the year for 2009. How
do I do that without having to type in each date?? I've done it once before,
but can't remember. Thanks for helping a newbie!
Lisa

Date Range
 

Hi,

Enter the date of the first Sunday in a cell (say) A1

04/01/2009

then in A2 enter =A1+7

drag down.

Mike

"msguirt" wrote:

I'm new to Excel (2003), so . . .
I'm trying to make a column to show every Sunday of the year for 2009. How
do I do that without having to type in each date?? I've done it once before,
but can't remember. Thanks for helping a newbie!
Lisa

Date Range
 

If the first one is in A1, the next is =A1+7, and copy down.
--
David Biddulph

"msguirt" wrote in message
...
I'm new to Excel (2003), so . . .
I'm trying to make a column to show every Sunday of the year for 2009.
How
do I do that without having to type in each date?? I've done it once
before,
but can't remember. Thanks for helping a newbie!
Lisa