On Wed, Nov 3, 2010 at 21:21, Rob Clement <[email protected]> wrote: > On 03/11/2010 12:55, Amichai Rotman wrote: > >> Hi All, >> >> Continuing my last question: >> >> I'd like to create a Sheet for each month. In column A of each sheet I'd >> like to automatically generate the specific month's dates: >> >> Is there a wizard I can use to specify the dates range (say: Nov 2010 till >> December 2010) and it will create a Sheet for each month with the dates >> automatically entered in column A - from A2 to A31 (or 30, if that moth is >> shorter). >> >> Of course I want to use it on a different file for next year too.... >> >> I hope I was clear enough... >> >> Thanks! >> >> Amichai > > I think the easiest way is this. > > 1) Create a start spreadsheet. > 2) On the top line cell A1 type in the 1st date in the month e.g. 1/11/10 > 3) On the second line below the 1st date set a cell a2 with = a1 + 1. The > cell will show 2/11/10 > 4) Copy cell a2 downwards for as many days as you require and the dates > will appear. > 5) In a new spreadsheet copy and paste the 31 days you require from the > first spreadsheet. Change the date at the top of the column to be whatever > start date you require and all the others will appear. > > I hope that it clear > > Thanks > > Rob > > Thanks!
This does provide some automation. What I was hoping for was some kind of a wizard like the ones for generating a yearly calendar - but under OOO Calc - will generate a sheet for each month with the correct dates (if a month has 28 days - it will generate it automatically, without me having to check first...) I would be pretty happy with some function I enter at the top of the column saying "Generate the dates for November 2010". -- .:====================================================:. Amichai Rotman Registered Linux User#: 201192 [http://counter.li.org/] Registered Ubuntu User #12851 [http://ubuntucounter.geekosophical.net] ------------------------------------------------------------------------------------------------------------ .:====================================================:.
