View Single Post
  #1   Report Post  
Steven
 
Posts: n/a
Default Excel : fill by example

Hi

Is there a similar function to the Lotus 1-2-3 "fill by example". I've
tried the Fill option under Edit, however can't seem to get it to work with
dates. For example if I enter in 3 dates in a column (see example below), I
would then like the next 20 or so rows for that column to be filled in with
dates incrementing by one week.

e.g

31.10.2005
07.11.2005
14.11.2005

thanks in advance.

Steven