Richard Travers 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.
Thank you everyone...this works and the formula!!
...Lisa
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]