Forum Discussion
allyherrm
May 25, 2021Copper Contributor
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'...
SergeiBaklan
May 25, 2021Diamond Contributor
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