Forum Discussion

joshbarryiow's avatar
joshbarryiow
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
joshbarryiow's avatar
joshbarryiow
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
  • 1QueenAJ's avatar
    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's avatar
      HansVogelaar
      MVP
      Feb 04, 2024

      1QueenAJ 

      I'm sorry, I have no idea how to do that.

      • 1QueenAJ's avatar
        1QueenAJ
        Copper Contributor
        Feb 06, 2024

        HansVogelaar Thanks so much for responding. I was coming here to see if I had any. I found this video: https://www.youtube.com/watch?v=TG0sfxahdsU&t=525s presented by ExcellsFun. It gave me the largest piece, which was the date manipulation. I've been using some data validation and will be looking into conditional formatting as well. Grateful you sent me down a different formula which led to this find. 

Resources