On 24/09/2007, Adrian Try <[EMAIL PROTECTED]> wrote: > > Hi Richard > > > Yes quite easily. > > Highlight cells. Go to Edit>Fill>Series. Set Direction =Down, Series > > Type = > > Dat, Time Unit = Weekday and increment = 2. > > I think the problem is actually quite tricky. > > Monday to Wednesday, and Wednesday to Friday, are both increments of 2. > Friday to Monday is an increment of 3 when thinking of the whole week, and > an increment of 1 when thinking of just weekdays. > > So we're incrementing by 2 then 2 then 3 (or 2 then 2 then 1). I can't > think of any easy way to use autofill to accomplish that. > > Adrian > > > > -- > Using Opera's revolutionary e-mail client: http://www.opera.com/mail/ > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > The "Weekday" option seems to work nevertheless. When I try it,it yields Mon 24 Sep 07 Wed 26 Sep 07 Fri 28 Sep 07 Mon 1 Oct 07 Wed 3 Oct 07 Fri 5 Oct 07 Mon 8 Oct 07 etc.
I suppose it might regard Saturday as a weekday. Hmmm. Actually, if I try an increment of 1 starting on 24 Sep with the Weekday option I *do not* get Saturdays. It jumps from Friday to Monday. Bug? -- Harold Fuchs London, England Please reply *only* to [email protected]
