Filling range with dates

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi



How can I fill a range of cells from top to bottom with dates such that it
starts with the first date of year and each subsequent date is a week later
i.e.



01/10/07

07/01/07

14/01/07

and so on



Thanks



Regards
 
hi,
in cell A1 enter 1/1/07. high light the column(range)...
Edit>Fill>Series>Type = Date, Date Unit = Day, Step Value = 7 > OK.

Regards
FSt1
 
Hi John

With your start date in A1, enter in A2
=A1+7
Copy down as far as you wish.

Changing the value in A1, will then automatically alter all of the other
dates.
 
Back
Top