creating a yearly Calendar

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Phillip Jones - 18 Dec 2006 19:19 GMT

I will post this intentionally here and excel group because I don't know
where it would apply.

Every year I have to make my mother a Calendar. I've had to come up with
my own design, and on formulas.

My Brother also uses MS Office, but at work and they use PC's . He said
why do you use the calendar template in Word.

I've been doing it in Excel.

So I've looked in Word and Excel. I can not find a Calendar. IS there
such a Thing.

What I am doing is the size of one of those standing desktop calendars
like you use to get from store, insurance companies, Funeral homes.

The on I create hold two months on one page printed in landscape mode. I
have 1/2" vertical and Horizontal Margins and set to be printed centered.

I have formulas figured for Sideways and up and down. But I have to
change the first few days in each month in order for the days to come
out right, and have to add or take away days at the end. This takes at
least an hour to do and proof to make sure, everything is correct.

Is there a Calendar template(s), available to do such a thing. I would
just like to open each year and it would automatically adjust according
to the Year.

If any one is interested in knowing what mine looks like I can send it.

Signature

------------------------------------------------------------------------
Phillip M. Jones, CET |LIFE MEMBER: VPEA ETA-I, NESDA, ISCET, Sterling
616 Liberty Street |Who's Who. PHONE:276-632-5045, FAX:276-632-0868
Martinsville Va 24112 |pjones@kimbanet.com, ICQ11269732, AIM pjonescet
------------------------------------------------------------------------

If it's "fixed", don't "break it"!

mailto:pjones@kimbanet.com

<http://www.kimbanet.com/~pjones/default.htm>
<http://www.kimbanet.com/~pjones/90th_Birthday/index.htm>
<http://www.kimbanet.com/~pjones/Fulcher/default.html>
<http://www.kimbanet.com/~pjones/Harris/default.htm>
<http://www.kimbanet.com/~pjones/Jones/default.htm>

<http://www.vpea.org>

Reply to this Message

Sol Apache - 18 Dec 2006 19:35 GMT

Hi Phillip
If you are using a Mac why not use iCal. You can set your page layout to 2 a
page (and use the border option) and if you cut the paper after printing on
A4 or US letter you will have a size about those of the insurance companies
and funeral homes.

Before you print, put all the events your mother needs on the calendar.

This will be a **lot** easier than creating a calendar in Excel or Word.

HTH

On 18/12/06 19:19, in article OUDk6ltIHHA.2232@TK2MSFTNGP02.phx.gbl,

> I will post this intentionally here and excel group because I don't know
> where it would apply.
[quoted text clipped - 26 lines]
>
> If any one is interested in knowing what mine looks like I can send it.

Reply to this Message

Daiya Mitchell - 18 Dec 2006 22:33 GMT

Yeah, use iCal. Or Entourage, if you are more familiar with that. Or
whichever program you *don't* use, although Entourage would let you
exclude your events, probably iCal also. Entourage insists on putting my
name in the footer, though, and the time I printed--iCal uses the time
zone and the page number, it seems.

Anyhow--easiest to use calendar software to make a calendar, on general
principle. :)

Daiya

> Hi Phillip
> If you are using a Mac why not use iCal. You can set your page layout to 2 a
[quoted text clipped - 42 lines]
>> If any one is interested in knowing what mine looks like I can send it.
>>

Reply to this Message

Phillip Jones - 19 Dec 2006 00:38 GMT

I tried iCal and does not print 2 months to a page side by side.
and the fonts are too much too faint.

it is easier, but for a version my mother can read I'll just have to
deal with it on the excel file. I only have to deal with once a year. So
its no deal breaker.

> Yeah, use iCal. Or Entourage, if you are more familiar with that. Or
> whichever program you *don't* use, although Entourage would let you
[quoted text clipped - 59 lines]
>>
>>

Signature

Reply to this Message

Jim Gordon MVP - 19 Dec 2006 01:12 GMT

Hi Phillip,

There is a lot of free software to be had for the asking. Try a Google
search for Free Excel Calendar Template. I had over 1 million hits. I'm
sure the vast majority of the hits aren't exactly that, but then a lot of
the hits meet the criteria.

If you don't mind dealing with Microsoft's quirky web site you can get free
templates from http://office.microsoft.com/ if the power gets restored in
Washington.

-Jim Gordon
Mac MVP

Quoting from "Phillip Jones" <pjones1@kimbanet.com>, in article
OUDk6ltIHHA.2232@TK2MSFTNGP02.phx.gbl, on [DATE:

Signature

Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info http://mvp.support.microsoft.com/

Reply to this Message

Phillip Jones - 19 Dec 2006 21:43 GMT

Are you referring to DC? or the State of .... . ;-)

> Hi Phillip,
>
[quoted text clipped - 43 lines]
>>
>> If any one is interested in knowing what mine looks like I can send it.

Signature

Reply to this Message

Elliott Roper - 19 Dec 2006 23:38 GMT

Oww! Phillip, that really Hertz!

> Are you referring to DC? or the State of .... . ;-)
>
> > Hi Phillip,

<snip>

> > If you don't mind dealing with Microsoft's quirky web site you can get free
> > templates from http://office.microsoft.com/ if the power gets restored in
> > Washington.

Signature

To de-mung my e-mail address:- fsnospam$elliott$$
PGP Fingerprint: 1A96 3CF7 637F 896B C810 E199 7E5C A9E4 8E59 E248

Reply to this Message

Jim Gordon MVP - 20 Dec 2006 04:38 GMT

It's called punishment...

Quoting from "Elliott Roper" <nospam@yrl.co.uk>, in article
191220062338557774%nospam@yrl.co.uk, on [DATE:

> Oww! Phillip, that really Hertz!
>
[quoted text clipped - 6 lines]
>>> templates from http://office.microsoft.com/ if the power gets restored in
>>> Washington.

Signature

Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info http://mvp.support.microsoft.com/

Reply to this Message

Phillip Jones - 20 Dec 2006 19:30 GMT

I didn't think I was insulting :-(

At least I wasn't intending so. :-(

Just wanting to know which Washington referred to.

I don't mind working with a Quirky Website from time to time.

> Oww! Phillip, that really Hertz!
>
[quoted text clipped - 5 lines]
>>> templates from http://office.microsoft.com/ if the power gets restored in
>>> Washington.

Signature

Reply to this Message

Jim Gordon MVP - 22 Dec 2006 04:28 GMT

We're just making bad jokes. Puns. As in "pun"ishment.

You may groan now.

-Jim

Quoting from "Phillip Jones" <pjones1@kimbanet.com>, in article
Osgoc1GJHHA.3264@TK2MSFTNGP02.phx.gbl, on [DATE:

> I didn't think I was insulting :-(
>
[quoted text clipped - 13 lines]
>>>> templates from http://office.microsoft.com/ if the power gets restored in
>>>> Washington.

Signature

Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info http://mvp.support.microsoft.com/

Reply to this Message

Paul Berkowitz - 22 Dec 2006 21:38 GMT

Since no one has answered you yet -

I think you're probably expected to know (here) that Microsoft is based in
Redmond, Washington (the state). Not DC. And you might possibly have heard
that Seattle and environs has had really serious winter storms that took out
the power for several days. (Actually no one has any idea where the download
servers are based, though. I somehow doubt it's Redmond, but you never
know.)

Signature

Paul Berkowitz
MVP MacOffice
Entourage FAQ Page: <http://www.entourage.mvps.org/faq/index.html>
AppleScripts for Entourage: <http://macscripter.net/scriptbuilders/>

Please "Reply To Newsgroup" to reply to this message. Emails will be
ignored.

PLEASE always state which version of Microsoft Office you are using -
**2004**, X or 2001. It's often impossible to answer your questions
otherwise.

> From: Phillip Jones <pjones1@kimbanet.com>
> Organization: VPEA
[quoted text clipped - 20 lines]
>>>> templates from http://office.microsoft.com/ if the power gets restored in
>>>> Washington.

Reply to this Message

Mac Forum / Applications / Excel / December 2006

creating a yearly Calendar