looking for ideas for calendar in sheet with separate months

[KR]

Our organization has a workbook that looks like a mini wall calendar, with
12 separate (months) groups of cells that are each 7 cells wide (7 days) and
6 cells high (up to 6 weeks). this calendar workbook is linked to outlook
and other stuff to keep trach of organizational schedule information.

Jan Feb Mar
******* ******* *******
******* ******* *******
******* ******* *******
******* ******* *******
******* ******* *******
******* ******* *******

Apr May Jun
******* ******* *******
******* ******* *******
....etc. (where each * represents a cell that has the day of the month in it)

In order to update the calendar every year, someone has to re-type the dates
in each month to update it to the new year. I already set it up to update
most of the month by having each cell value equal to the previous cell +1.
Then I delete the days at the top and bottom of the grid that don't apply
for that month (e.g. if the month starts on Wednesday, I clear the cells in
the top row that correspond with Sun, Mon, Tues).

Seems to me there must be a way to just tell the worksheet that it is for
2006 (a single cell entry) and have all the monthly calendar blocks show the
correct days (and blank the unused days) using formulas- but I haven't come
up with anything that works yet.

Any suggestions?
Thanks!
Keith

 

[Guest]

Since there are only 14 possible calendars. (1 january starting on one of
seven days for normal and leap years) I strongly suggest that you create
the fourteen possibilities and use the appropriate one for any given year.

No formulae need to be maintained.

 

[Paul B]

KR, there is one here you might want to have a look at.

http://www.vertex42.com/ExcelTemplates/yearly-calendar.html
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003