Use Vintage Calendars

There are only 14 unique calendars; this instructable will teach you how to use Excel to make a list of calendars by year, so you can display your vintage calendars that are accurate for the current year. You can also use this technique to display a calendar from the future instead of a vintage calendar. The instructions laid out here work with any current version of Excel, although the instructions will be based on using Excel 2007.

This instructable will also demonstrate some time-saving Excel tips.

Step 1 The Fourteen Calendars

There are fourteen possible patterns for calendars; the list below shows all of the possible calendars.

Type 1: Year starts on Sunday, but it's not a leap year
Type 2: Year starts on Sunday, and it's a leap year
Type 3: Year starts on Monday, but it's not a leap year
Type 4: Year starts on Monday, and it's a leap year
Type 5: Year starts on Tuesday, but it's not a leap year
Type 6: Year starts on Tuesday, and it's a leap year
Type 7: Year starts on Wednesday, but it's not a leap year
Type 8: Year starts on Wednesday, and it's a leap year
Type 9: Year starts on Thursday, but it's not a leap year
Type 10: Year starts on Thursday, and it's a leap year
Type 11: Year starts on Friday, but it's not a leap year
Type 12: Year starts on Friday, and it's a leap year
Type 13: Year starts on Saturday, but it's not a leap year
Type 14: Year starts on Saturday, and it's a leap year

Comments

[Red Monkey]

A shame this doesn't work in OpenOffice; it gets stuck at step6 and comes up with 'error508'.

[KEUrban]

Sorry. I don't have Open Office installed.

Any Open Office experts out there that might have some advice? The functions in OO should be the same as modulus is fairly common.

I'll see what I can figure out myself as well.

In the meantime, one way to troubleshoot malfunctioning formulae in any spreadsheet is to break up the components: Try just =YEAR(A2) in a cell and see if that works. If it does, then try =MOD(YEAR(A2),4). If all else fails, you can add multiple columns to build the parts of the formulae you need (i.e. one column for the YEAR calculation, one for the modulus operations, et cetera. Let me know if that works, or if you're an OO expert, please post comments or suggestions.

Thanks for your comment.

[Red Monkey]

Thanks for that; it's very helpful of you. I don't use spreadsheets at all so your Instructable was a nice incentive to have a go.

[Michael3216]

My computer doesn't have that, it has "Sort Ascending" and "Sort Descending" so what do I do?

[KEUrban]

Use "sort ascending". That will work just fine.

[pandyaketan]

pl attach the final files... (and save trouble to thousands of users) ;-D reg ketan

[vast]

Ingenious , took 5 minutes, and should rescue a few old unused calenders form the 'should recycle' pile.
In Excel 2003 I had to click Data (from the menu bar) then Sort to achieve step 10.

Typo:
I'm guessing the beginning of step4 should be enter =A2 not enter =A1

[KEUrban]

Nice catch! Thanks, I fixed the typo.