Forum Discussion
Solved
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 grea...
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.
My ideal outcome would be a calendar that shows all of the months of a year, with the days, and being able to type in a year to change that view. Basically, a function that can keep the numbers of a day (like Excels built in numbering system) and spit out a view that would look similar to the Julian calendar, but the fantasy world calendar. Similar to mathetes idea.
The story I’m writing is one of a series of stories. The current story has time travel over 200 years, and some dates being referenced, so it would be nice to “realistically” bridge that gap of time, instead of just guessing the dates. Also, a later story focuses specifically on one week way later in the future from the first story. Because of that distance, and because I want to keep day, month, and year continuity, I’d like to see each year laid out by months with the months showing days, much like a 12-month calendar of ours would have. But the fantasy world 14 month calendar. Basically, a micro-macro view.
Does that make sense? Or does it seem like I’m running in circles? Thanks!
The story I’m writing is one of a series of stories. The current story has time travel over 200 years, and some dates being referenced, so it would be nice to “realistically” bridge that gap of time, instead of just guessing the dates. Also, a later story focuses specifically on one week way later in the future from the first story. Because of that distance, and because I want to keep day, month, and year continuity, I’d like to see each year laid out by months with the months showing days, much like a 12-month calendar of ours would have. But the fantasy world 14 month calendar. Basically, a micro-macro view.
Does that make sense? Or does it seem like I’m running in circles? Thanks!
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.
- You're welcome and best of luck
- Let us know when the book comes out.
- Yes! This looks fantastic! Thank you! And thank you to mathetes for helping too! I’ve appreciated both of you guys’ help and interest in this project!
Great job! I was still in the earliest stages; would have taken a few more days...
ChristianHauer I'm going to assume this meets your every need unless you come back looking for more.
