Thank you very mouch for your very detailed reply it is most appreciiated not
many people bother replying like that anymore. It is for general interest
only so I might take a look at his book if I can find it

Thanks again Joel
--
N/A


"JLatham" wrote:

Joel,
The answer to this one is filled with a lot of "if"s , "but"s and "maybe"s.
Basically the answer is yes, but how easy it would be to do depends much on
your current calendar layout. John Walkenbach has a massive array formula
published in some of his books on Excel that will automatically provide a
calendar for any month/year combination. The 'problem' with it is that the
cells are occupied by the formula/date and you can't type notes into the
cells - but for printing a calendar for desk or wall, it's great.

For setting up calendars to have a date on one row with note area
underneath, things get a bit more complicated, but still do-able. Mostly
this would all be handled by VBA code (if I did it - as I have in the past).

It's almost easier to do it manually - start with a calendar for January and
enter the date for January 1st manually, then in the rest of the month's
cells you put a formula that adds 1 day to the previous day's date for each
day of the month. For Feb thru Dec, you go to the proper day of the week in
that month's calendar area and add 1 day to the last day of the previous
month, then continue with the add 1 day formula for the rest of it. As I
said, this can also be done with VBA code or with an array formula such as
Walkenbach has published.

"Joel" wrote:

Hi I was wondering if you could please help

I have made a calender in Excel for this year 2008 on sheet 1 it just shows
a table devided into 12 months with the relevent dates

My Question is can I get it to generate a calender 2009 with the with the
correct date on automatically on sheet 2 and so on

Thanks Joel
--
N/A