Forum Discussion
TBennett2015
Nov 08, 2023Copper Contributor
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
Sort By
- Riny_van_EekelenPlatinum Contributor
TBennett2015 And exactly which template would that be?
- TBennett2015Copper Contributor
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_EekelenPlatinum 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: