Calendar Creation in Excel

[Duncan Edment]

I was tasked with creating a calendar in Excel, that could then be
printed and used in our department. The calendar had to be created to
specific requirements:

1. The last three months of 2004 had to be included;
2. The full of 2005 had to be included;
3. The first three months of 2006 had to be included;
4. The reverse of the calendar had to show the full year for 2004
and the full year for 2006;

Items 1, 2 & 3 had to follow on from each other and had to be in the
format with the days down the sides and the months along the top.

As I couldn't find a template that would do this, I had to manually
enter each months dates and set the calendar up exactly how we required
it.

So, my question is, does anyone know of a template that will achieve
this format? Or, is there some other way, so that come the end of this
year, I can simply open it, change the staring date for the 1st October
2005 from a Friday to a Saturday, and the rest will be filled in
automatically?

Tough order, but I hope someone can help.

TIA

Duncan

--
Newsgroups are like one big sandbox that all of us
UseNet kiddies play in with peace & harmony.

Spammers, Cross-Posters, and Lamers are the
people that pee in our big sandbox.

To e-mail, please remove NO_SPAM.

 

[NewsMan]

This might help you out:

http://www.ozgrid.com/VBA/excel-calendar-dates.htm

 

[Harlan Grove]

Newsgroups are like one big sandbox that all of us
UseNet kiddies play in with peace & harmony.

Spammers, Cross-Posters, and Lamers are the
people that pee in our big sandbox.

You are clueless and don't frequent advocacy newsgroups.

You are also deluded into believing cross-posting is bad likely because
you're incapable of distinguishing it from spam. Limited cross-posting to
relevant newsgroups is always OK (e.g., question on device drivers posted to
comp.lang.c and comp.sys.hp.hardware, or questions on batch scanning system
logs to comp.lang.perl.misc and comp.os.ms-windows.admin.misc). Posting O/T
messages to any newsgroup, whether to a single one or multiple cross-posted
ones, is always bad. Multiposting is pure evil.

Don't advertise your ignorance in your newsgroup signature.

 

[Arvi Laanemets]

Hi

When you are interested, I can send my calendar - full year, 12 months in
columns, month days in rows weekwise, weekends and state holidays (for
latter you have to edit holiday list formulas - at moment it contains
estonian state holidays) colored differently. You enter any year number up
from1900, Excel is capable to calculate dates of, and the calendar for
according year is displayed. Additionaly you can calculate ISO weeknumber,
day number (in year) and weekday for any valid Excel date.
The calendar is designed to be printed out on A4 landscape sheet.

 

[Duncan Edment]

You are clueless and don't frequent advocacy newsgroups.

You are also deluded into believing cross-posting is bad likely
because
you're incapable of distinguishing it from spam. Limited cross-posting
to
relevant newsgroups is always OK (e.g., question on device drivers
posted to
comp.lang.c and comp.sys.hp.hardware, or questions on batch scanning
system
logs to comp.lang.perl.misc and comp.os.ms-windows.admin.misc).
Posting O/T
messages to any newsgroup, whether to a single one or multiple
cross-posted
ones, is always bad. Multiposting is pure evil.

Don't advertise your ignorance in your newsgroup signature.

And tell me, Harlan Grove, who died and made you God? Who gave you the
right to criticise my post, or should I say, my signature?

Duncan

....
Newsgroups are like one big sandbox that all of us
UseNet kiddies play in with peace & harmony.

Spammers, Cross-Posters, and Lamers are the
people that pee in our big sandbox.

To e-mail, please remove NO_SPAM.

 

[Harlan Grove]

Duncan Edment wrote...

And tell me, Harlan Grove, who died and made you God? Who gave you the
right to criticise my post, or should I say, my signature?

....

I was born with the right to criticize it, and the need to do so
springs from your own foolishness.

You obviously don't know how to distinguish several of the terms in
your newsgroup signature, so your time would be better used trying to
learn what they mean and how they're actually perceived than to try to
rant in response to me.

For instance,

http://www.cs.indiana.edu/docproject/zen/zen-1.0_6.html#SEC52

But if you must, please do consider me puking on you in your sandbox,
and depend on it that I'll continue to do so as long as you present
such an appealing target.

 

[Duncan Edment]

To e-mail, please remove NO_SPAM.

Duncan Edment wrote...
...

I was born with the right to criticize it, and the need to do so
springs from your own foolishness.

You obviously don't know how to distinguish several of the terms in
your newsgroup signature, so your time would be better used trying to
learn what they mean and how they're actually perceived than to try to
rant in response to me.

For instance,

http://www.cs.indiana.edu/docproject/zen/zen-1.0_6.html#SEC52

But if you must, please do consider me puking on you in your sandbox,
and depend on it that I'll continue to do so as long as you present
such an appealing target.

Mr Grove.....PLONK!!!

--
Newsgroups are like one big sandbox that all of us
UseNet kiddies play in with peace & harmony.

Spammers, Cross-Posters, and Lamers are the
people that pee in our big sandbox.

 

[G. Harper]

Hi

When you are interested, I can send my calendar - full year, 12 months in
columns, month days in rows weekwise, weekends and state holidays (for
latter you have to edit holiday list formulas - at moment it contains
estonian state holidays) colored differently. You enter any year number up
from1900, Excel is capable to calculate dates of, and the calendar for
according year is displayed. Additionaly you can calculate ISO weeknumber,
day number (in year) and weekday for any valid Excel date.
The calendar is designed to be printed out on A4 landscape sheet.

Hi Arvi,
Please send me that calendar. Or, post it here.
I made a simple calendar but I sat there and thought out all relavent
dates and added them myself.
I'd enjoy seeing how you make excel do the calculations, and this
would benefit my excel knowledge.

Thank you,
GH