Every Sat Date Population

R

Roberta

How can I get it to populate the dates for every Saturday starting from
12/31/05 until the end of the year?
 
R

Ron Coderre

To Excel, dates are just numbers...

Try this:
A1: 12/31/2005
A2:=+A1+7
Copy that formula down as far as you need and format the cells as dates.


Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
C

CLR

Ron gave you the easiest way, but an alternative would be, with 12/31/05 in
A1, highlight A1 and as far down column A as you want dates, then do Edit >
Fill > Series > check Columns, Date, Day > Enter Step Value as 7 > OK

Vaya con Dios,
Chuck, CABGx3
 
Top