This can be an application in itself. You can try to make your own Excel sheet, but all the attempts I've seen break or fail in one year.
I'm currently trying to create a Calendar to work out the holidays at my work place, is there any way of counting formatted cells, or maybe Inserting the dates and it automatically putting it on to my calendar??? I want to be able to see at a glance what Holidays people of booked and I think this would make it easier. is this possible or am I being to ambitious??
I hope someone can help!
I don't understand at all what you would want to do, so I can't offer any tips at all.
Your teachers at college surely don't want you to do the impossible. And they might be able to help you about what is possible or feasible, and what's not. I'm a (part-time) teacher myself, and I can assure you most of us want the students to pass their exam and will help them if they seem to go the impossible roads.
Forget the very difficult task (I didn't say impossible) of trying to use Excel to create a calendar.
If you have Office, there is already a Calendar Wizard there for you to use.
There may be other ways of getting to the "New Office Document" window to see the various templates and wizards, but here is one way:
Start>All Programs>New Office Document
There select the "Other Documents" tab, and click [Open]
Answer the 3 questions and have a Calendar the way you want. It is pretty cool, and definitely easy.
!-!-!-! OR !-!-!-!
use Microsoft Outlook.
Just select the Calendar,
select File>Page Setup
select one of the various styles there (daily, weekly, monthly, etc).
That's pretty cool too.
You can setup Outlook to automatically include US Holidays, or other countries, or religions (Jewish, Islamic, Christian). (See Tools>Options, [Add Holidays]
And finally you can print an entire range of dates, a week, a month, a lot of months, even with more than one month on a page. Or how about to print small sizes, so they'll fit into your Day-Planner. Try it.
FINALLY, you could go to Microsoft Office Online. There are a number of various templates, including calendars already there for your use.
Pint-size luxury and funky style
Shopping for a new car this weekend? See how the BMW X2 stacks up against the Volvo XC40 in our side-by-side comparison.