Forum Discussion
Re: Creating a Fantasy Calendar
But wouldn’t that show me the figures for the Julian calendar? I would like to have the figures for the fantasy calendar. Also, my preference would be if I could have all 14 months of a year displayed in block format on a worksheet, like we might have in a “planner” document for Excel with our 12 month calendar. And then be able to change what year I’m looking at by typing in a new one. I don’t know how feasible that is, but that’s what my ultimate goal would be.
I hope that makes sense. Thanks for your insights!
I hope that makes sense. Thanks for your insights!
9 Replies
- so I was trying to suggest if you have a lookup to go from day-of-year (i.e. 1-365/366) to fantasy date and back. Since both calendars are based on same #days/year (inc leap years) then you convert it to our calendar, use excel function, then convert it back to fantasy calendar all based on day#. I think it should work. My only concern is the days between the 2 leap days in leap years but like I said you need to account for that in the lookup table.
As for creating a 14 month planner that is done using various techniques. Depending on the technique used may depend on how you would adapt it for your fantasy calendar..- I have very little knowledge of commands in Excel, so I wouldn’t know how to make that from scratch. But if you could help me with the commands I would need, or know of a YouTube video or similar tutorial that could show me all of the different pieces I need to put that together, I could work at it.
- Sry from the context I thought you had a template already (e.g from the web or something) that you wanted to adapt.
I'm still confused what the spreadsheet will be used for. Is this just a tool for you to create a consistent date in the alternate calendar or to see year's of this alternate calendar? In one case you talked about needing a function that can tell you # days between 2 dates and another location you want to see a 14 month planner based on a year. Is any format for this ok? Do you really need all 14 months of a single year or would it be more useful to have the month of a starting date and the month of the end date and # days between? Really hard to guess what you are looking for when we don't know what for/ how you're are planning to use it.
