On 24/09/2007, Richard Travers <[EMAIL PROTECTED]> wrote: > > In article <[EMAIL PROTECTED]>, > Lisa Hetherington <[EMAIL PROTECTED]> wrote: > > I would like to have cells A1-A20 to have the dates of every Mon Wed > > and Fri, ie > > 9/24/07 > > 9/26/07 > > 9/28/07 > > 10/1/07 > > 10/3/07 > > 10/5/07 > > etc > > etc > > > Can Calc do this? > > Yes quite easily. > > Highlight cells. Go to Edit>Fill>Series. Set Direction =Down, Series Type > = > Dat, Time Unit = Weekday and increment = 2. > > This should give you what you want. > > R. > > -- > > Richard Travers > [EMAIL PROTECTED] > Truro, Cornwall
You need to set the start date as well . -- Harold Fuchs London, England Please reply *only* to [email protected]
