[EMAIL PROTECTED] wrote:
On Sunday 23 September 2007 22:50:17 Lisa Hetherington 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?
..Lisa
-----------------------------------------------------------------
---- To unsubscribe, e-mail: [EMAIL PROTECTED] For
additional commands, e-mail: [EMAIL PROTECTED]
Yes, drag with some editing. This one of those times when the Linux
Fedora version shines because it has a dialog box that can control
the increment.
Click in the A1 to select it cell move mouse to the bottom right
corner of cell A1 over the dot click and drag down.
I have A1-A3 filled in (cells are formated as Date, User Defined, mmm dd)
I clicked on A1..dragged down...I got
Sept 24
Sept 25
Sept 26
Sept 26
Sept 27
Sept 28
Sept 29
Sept 30
Sept 31
Sept 32
Sept 33
Sept 34
and so on .....
when I filled in A1-A6 with this:
Sept 24
Sept 26
Sept 28
Oct 01
Oct 03
Oct 05
and highlighted and dragged them, I got this:
Sept 24
Sept 26
Sept 28
Oct 01
Oct 03
Oct 05
Sept 25
Sept 27
Sept 29
Oct 02
Oct 04
Oct 06
Might be just quicker to type the dates in!
...Lisa
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
