In article <[EMAIL PROTECTED]>, 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. Nevertheless, doing what I suggested does produce the desired result (try it and see). R. -- Richard Travers [EMAIL PROTECTED] Truro, Cornwall --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
