Forum Discussion
Custom calendar dates
See if you can adapt the attached calendar (based on one of Microsoft's templates) for your purpose.
- Thank you, that certainly looks like a better calendar for this application. I suppose it would be a case of trying to work out how to adapt that to start and finish on a certain date or just to remove dates each side possibly? This one is using an NDX formula so I'll have a play around
You can play with the shading and/or conditional formatting to hide the dates outside the desired period.
HansVogelaar -- Hello, I'm hoping you can help, if not thanks for at least reading.
In my search to find an appropriate method to make a custom calendar based on the zodiac dates this seems to be the closest solution. The problem is that I am an amateur when it comes to Excel. I just know it can do powerful things. I already have the data in the sheets and the layout of the calendar but ....
Making the calendar start on Aries - March 19-21 (depending on the year) and making the calendar end at the end of Pisces March 18-20. The calendar is based on the zodiac and starting the calendar on the Spring Equinox.I've attached a link to the google doc which i know isn't excel but it can be downloaded for comments. I appreciation and thank you in advance if you or anyone can assist. https://docs.google.com/spreadsheets/d/1CPCh9oqvweobkUI-a3_rr9lddRYrQaVr/edit?usp=sharing&ouid=114380191425301544757&rtpof=true&sd=true
Thanks
QueenAJ
