Date Range

M

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
 
M

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
 
Top