Forum Discussion

Michele_Warren's avatar
Michele_Warren
Copper Contributor
May 29, 2024

Calendar Template

I have downloaded a calendar template for excel that I like.  As I am creating new months for the calendar it stops in October 2024 from the dropdown tab.  How do I create the other months of this year and for 2025, which are not listed in the dropdown tab on the excel sheet?

3 Replies

  • dscheikey's avatar
    dscheikey
    Bronze Contributor

    Michele_Warren 

    The dropdowns are created with the data validation or with macros. In the first case, go to the cell in the menu on data validation and look at the list or the formula that is there. If you get stuck, post the content here.

    • Michele_Warren's avatar
      Michele_Warren
      Copper Contributor

      dscheikey 

       

      This is what it shows me.  I do not see where I can change a date validation.  Am I looking in the wrong spot?

       

       

      • dscheikey's avatar
        dscheikey
        Bronze Contributor

        Michele_Warren 

        Click in the cell with the dropdown. Not on the arrow.

        In the Data menu, go to Data Validation.

        There you will find the origin of the list that is displayed in the dropdown.

        It could also be a formula.

        Post the content here and you will be helped.

         

Resources