Is there a way to create my own Calendar for my novel?

Question

So i am writing a very big series of books, and the idea is that i will create one of the most detailed universes there is out there.

I've been doing my math and decided that one of my occupant planet's each week is 8 days long but each day is 21 hours resulting each week to be 168 hours long. (Same as on planet earth). Each year has 420 days, 8,820 hours, 52.5 weeks, split into 12 months and each month has 35 days with 4.375 weeks each month. (the extra day is called funday and it's after Friday bc weekend is next so yay fun). Now i want to make a calendar with all that in mind, so that i can start from the beginning. When they started counting it was Mon 1st 1st year of January and ended as Thur 35th 1st year of DEC. one of my books is set in 2500 years after that and i want to know exactly what day and numbers i should put into the days i am describing. I know it's too much but again, i want it insanely detailed.Is there a way i can do this without spending an eternity on Excel making 2500 years worth of calendars? An algorithm or a program or something that can help me do it faster? I want the whole calendar though because i have about 4 books on that planet on different years and the book i am focusing now covers about 30 years so i at least need those 30 years. Below i attach the first year ever recorded.

Zac Z · Answer

I'm not exactly sure what you are asking about but it's much simpler than you apparently think.

Your calendar is very regular, unlike our own with its differing month lengths and leap years. The pattern of days in a month repeats every 8 months; your September is identical to January in regards of the day of the week. And because there's 12 months in your year and 24 is divisible by 8, the pattern repeats every other year.

Therefore, there are really only two possible calendars for your world: one for odd years where the 1st of January is a Monday; one for even years where the 1st of January is a Friday!

In other words, the calendar of the year 2500 looks exactly like the calendar of the year 2; the calendar of the year 2501 is identical to the calendar of the year 1 (or year 3, year 5, etc.).

By the way, I suggest you get a little more familiar with Excel. It's worth it. It would be very easy to calculate the day of the week for a regular calendar as the one you've constructed. Using the date you can easily calculate how many days any given date is removed from 1st of January, Year 1. This number contains the information of which day of the week it is (by either applying mod 8 or dividing it by 8 and looking the figure after the decimal point). I could cobble together a simple Excel sheet in two or three minutes where you plug in a date and get the day of the week as a result. No eternities involved.   ;-)
But as I've explained above, since your calendar repeats every two years it's probably more practical for you to just make the one for the even years and use those two are they are more visual than a formula.

Is there a way to create my own Calendar for my novel?

Trending Questions