Excel Calendar 2009
Posted on November 11, 2008
Filed Under Calendar |
Less than two months we will enter the year of 2009. Usually around this time, I am looking for the new design of excel calendar, but this year is different. I plan to make my own excel calendar, so I can define anything I want in this calendar.
What I want to have in my calendar is a flexibility to change my holiday and event date without changing the appearance of the cell containing the date manually. It is annoyed me. The thought is how to make the appearance of the cells changed automatically everytime I change the date of the holiday/event or add the new holiday/event in separate cells. And after several layout changing, I made this calendar as you can see in the picture, where I made the column for holidays and event where I can fill or copy my holiday and event in those columns and see the corresponding date in the calendar changed its appearance. And you can do this also with this excel spreadsheet.
I add also another function which will make this calendar not just as an excel calendar 2009 but also become a perpetual calendar that you can use everytime the year is changed either forward or backward.
You are free to change the layout or the appearance of this calendar according to your preferences.
You can download this calendar here.
You can download the openoffice version here.
Happy new year!
Comments
3 Responses to “Excel Calendar 2009”
Leave a Reply
Hi! I would like to change it to year 2010 and add more colors. Can you tell me how to do that? Thanks!
You can download my yearly calendar where you can change the year and all dates will be adjusted automatically.
Regards
Hi,
This is exactly the format for a calendar I’ve been looking for, thanks!! I was wondering if you could let me know how to add more colors for other categories?