Forum Discussion

Copper Contributor

Oct 25, 2023

Custom calendar dates

Hi, I'm trying to create a custom calendar for staff timesheets. Our payroll require the dates to run 6th of each month to the 5th of the next month to fall in line with the tax year. How do I edit ...

Formulas and Functions

MVP

Oct 25, 2023

See if you can adapt the attached calendar (based on one of Microsoft's templates) for your purpose.

Any year one-month calendar1.xlsx14 KB

Copper Contributor

Oct 25, 2023

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

HansVogelaar
MVP
Oct 25, 2023
joshbarryiow

You can play with the shading and/or conditional formatting to hide the dates outside the desired period.
Any year one-month calendar2.xlsx14 KB
- 1QueenAJ
  Copper Contributor
  Feb 04, 2024
  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
  - HansVogelaar
    MVP
    Feb 04, 2024
    1QueenAJ
    
    I'm sorry, I have no idea how to do that.

Resources