First a bad news: I am leaving to India tomorrow and that means there will not be many blog posts in the next week or so. Once I reach home and get an internet connection, the updates should be regular.
Now the good news: free excel calendar template for year 2009 (well, it works for any year all the way up to 9999)
Go ahead and download it, change the year number in the first sheet to 1981 or something and see the magic.
More importantly, the workbook is unlocked so you can see what formulas are being used. There is a worksheet named “mini” which calculates the calendar dates and weekdays for the year specified by you. Once that is done, I have used references to create a 12 month view in the first sheet.
There are 12 more sheets each for one month in the year. These sheets use a combination of named range based references along with cell() formula to automate the whole thing. Oh yeah, they also use camera tool outputs to show you previous and next month calendar views.
So, download, share it with a colleague or use it as you wish: Excel Calendar for year 2009 – Download and Print Free
PS: I have tested this in Excel 2003 and I guess it should work the same way in 2007. Let me know if you see something funny.