Forum Discussion

ChristianHauer's avatar
ChristianHauer
Copper Contributor
Jan 03, 2022

Creating a Fantasy Calendar

I am working on a story based in a fantasy world and want to make a calendar for it in Excel (there is time travel and different eras in the world so I think having the months/days/years would be great for continuity). I am looking for a way to either create a new “date()” function or a simpler way to make the calendar than having to type out each month/week and copy paste till I get 10 years down the calendar. I most commonly use Excel on Mac, but I can get access to a Windows version if that makes it easier. I appreciate any advice that anyone can give me!
Excel
Excel on Mac
Formulas and Functions
Macros and VBA
  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor
    Jan 03, 2022

    ChristianHauer 

    Download a calendar template:

    Browse through the calendar templates (or create one), choose an Excel calendar template that is best for you. Click the Download button on the template page, open the template file in Excel, and then edit and save your calendar.

    Note: By default, a template file download goes into the Downloads folder on your computer. You may want to copy the template file to a different location so that you can easily find it later.

     

    Hoffe das ich Ihnen mit diesen Informationen weiterhelfen konnte.

     

    Nikolino

    I know I don't know anything (Socrates)

    • ChristianHauer's avatar
      ChristianHauer
      Copper Contributor
      Jan 03, 2022
      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.
      • mathetes's avatar
        mathetes
        Silver Contributor
        Jan 03, 2022

        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.