Forum Discussion
Modify Existing Calendar Template
I'm using the "Family Event Calendar" excel template, and I would like to modify it to have a start and end date and highlight the days in between on the monthly tabs associated with the date. I don't know how to add the formulas without messing up all the existing formulas/rules.
9 Replies
It depends on which version of Excel you are. If 365 that will be bit easier. In any case you need to add another column and use Start/End columns instead of Day. Instead of VLOOKUP that could be INDEX/MATCH/INDEX.
Better with sample, if you generate Start/End
There are SO MANY templates for calendars, could I ask you to post a copy of the actual template you're working with, so we who would like to help don't have to take time to search and possibly find a different one anyway.
At the same time, I'm going to send a link to your post to somebody in Microsoft who has some responsibility for templates...if it's an official Excel template, somebody there might be able to help.
In general, though, I'd just make the observation that the templates often serve more to get you started and show what's possible, but they can be hard to modify...
- I didn't find one by that name in the FIle...New set.... but could be from the microsoft website. In any event, I did send a link to the question to the Microsoft Template person.
