creating a yearly Calendar

P

Phillip Jones

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.
--
------------------------------------------------------------------------
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 |[email protected], ICQ11269732, AIM pjonescet
------------------------------------------------------------------------

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

mailto:p[email protected]

<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>
 
S

Sol Apache

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
 
D

Daiya Mitchell

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
 
P

Phillip Jones

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.

Daiya said:
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

--
------------------------------------------------------------------------
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 |[email protected], ICQ11269732, AIM pjonescet
------------------------------------------------------------------------

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

mailto:p[email protected]

<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>
 
J

Jim Gordon MVP

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


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.

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info
 
P

Phillip Jones

Are you referring to DC? or the State of .... . ;-)
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

--
------------------------------------------------------------------------
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 |[email protected], ICQ11269732, AIM pjonescet
------------------------------------------------------------------------

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

mailto:p[email protected]

<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>
 
P

Phillip Jones

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.

Elliott said:
Oww! Phillip, that really Hertz!

--
------------------------------------------------------------------------
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 |[email protected], ICQ11269732, AIM pjonescet
------------------------------------------------------------------------

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

mailto:p[email protected]

<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>
 
J

Jim Gordon MVP

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

You may groan now.

-Jim


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.

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info
 
P

Paul Berkowitz

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.)

--
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top