Yep, that is exactly where I was heading, but haven’t had a chance to go back into it.
I haven’t had a chance to go through what you put together, but this template takes where I was heading and supports automatically generating dates without having to upload them.
There is still a lot to do, like handle weeks, but when working with this I found it important to take a specific approach to how the data was being related. This takes a top down approach where each date type knows how to create missing related date entities.
I do wish there was better support for applying a consistent approach to entities you want the dates related to, so I ended up framing out an area associated with the Dates (Date Settings), which would provide a place to configure how the template behaves and potentially having it apply stuff to other databases that you configure there.