Forum Discussion
Creating a Fantasy Calendar
ChristianHauer see if the attached does everything you want. I locked the sheet except the 2 green cells where you enter the start & end dates but there is no password if you want to unlock it.
ChristianHauer wrote "But will that make it so I can customize how many days are in a month? Because the fantasy world has varied days in a month compared to the Gregorian calendar."
Ahh, Narnia meets Lord of the Rings meets Wrinkle in Time
May I suggest you spell out a bit more fully how much the days in those fantasy months might vary. Are there twelve fantasy months, more or less, or does that number itself vary. Do the number of days in Januly vary each time Januly rolls around? Or is it just that Januly has 15 days whereas Febember has 44?
And so forth?
I think you're going to have to create a new function, which can be done in Mac or in Windows, but you need to spell the situation out a bit more before anybody can help.
- There are 14 months (365/366 days in a year), the days per month are as follows: 26, 26, 22, 26, 27, 26, 30, 26, 25, 26, 26 (leap year 27 [every four years]), 26, 26, 27.
Well, here's a start. I'll keep noodling on this to see if I can turn it into something more functional. And let's invite others to do the same.
How do you plan to use this calendar IN your fantasy world? This includes such things as "Are there seven day weeks?" "Do the days of the week have names?" Or some other span called a week? And so forth..... All of those kinds of questions would be important to think through in order to start using that matrix meaningfully.
- The weeks are seven days long. I do have names for the individual days/months. However, I wasn’t sure that was important for the function. If we can use the place holders you came up with for now, mathetes, that would be nice.