Date Range

[msguirt]

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

 

[Mike H]

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

 

[David Biddulph]

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