Excel diary: a thing of beauty
Today I created one of the most beautiful spreadsheets I’ve ever created. It should have universal appeal, is simple in concept but more cumbersome than you might imagine to implement.
It’s a calendar.
It shows the days of any year you choose (from 1900 to 9999) in the traditional diary-style monthly view, with days of the weeks as columns, each week appearing below the next. Each month prints out on a different page and it takes into account leap-years, including the less well-known 100-year and 400-year rules.
Here are the 2008 version (53Kb) and the 1997–2003 version (oddly, 212Kb). On the Annual sheet, enter your year of choice. And your more detailed calendar will appear on the Calendar sheet.
Oh and by the way, 31 December 9999 will be a Friday. And what a Friday night it will be.
Comments
Leave a Reply