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!