Free Excel Calendar Template for year 2009 (and all years up to 9999)
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.
Introducing our Online Power BI Class:
Would you like to join me on a date with Power BI? In this comprehensive online class, learn all about Power BI so you can create beautiful, insightful & interactive reports. Join me and rest of the play mates for our first ever Power BI Play Date.Click here to know more and join us.
Leave a Reply
|Parking Tickets in New York – Cool Interactive Visualization from NYTimes||Brick Charts in Excel – an Alternative to Gridlines|