Forum Discussion

TBennett2015's avatar
TBennett2015
Copper Contributor
Nov 08, 2023

Excel Calendar Template: Extend date range

I am using an excel calendar template I downloaded through office 365.  I can't figure out how to extend the date range.  It only goes up to April 2024.  Any help would be greatly appreciated!!

3 Replies

    • TBennett2015's avatar
      TBennett2015
      Copper Contributor

      Riny_van_Eekelen 

      Through office 365 I was able to download a monthly calendar with a split page format.  I cant seem to find it in the templates now.     Here is a screen shot. 

      I am trying figure out how to extend the dates for this template.  The month options are limited to September 2023 - April 2024.

       

       

       

      • Riny_van_Eekelen's avatar
        Riny_van_Eekelen
        Platinum Contributor

        TBennett2015 I recognise that one but it doesn't show up in the gallery when I want to create a new file from a template. And I can't find it online right now either.

         

        This is probably one of the worst and less useful calendars 'out there'. If I remember correctly the dropdown list is connected to a range on a hidden sheet. If you could upload the template or if you could share a link giving access to a copy of your the file (Onedrive or similar) with all private entries removed, that would help. 

         

        Or if you want to have a go at Data Validation options yourself, have a look at the basic info in the link below:

        https://support.microsoft.com/en-us/office/apply-data-validation-to-cells-29fecbcc-d1b9-42c1-9d76-eff3ce5f7249 

Resources