Forum Discussion

DaveG's avatar
DaveG
Copper Contributor
Jan 21, 2025

Date Tracker - Calendar View

Hi,

I'm looking to create a yearly calendar view that for example shows all the Bank Holidays by country thats listed on another tab.

 

Tab 1 is the overall view that has all the dates across the top and each row represents a country

Tab 2 is the data view. Have all the BH dates listed by country

Tab 3 is black out periods - between 2 dates that all have to go onto 1 row. Example in yellow on the cal view

How do i pull these into the overal view to highlight the days on each row to give me a yearly view of everything.

 

Here is the https://1drv.ms/x/s!AmQDmoyCLvWpcwyhg7eKIyp8Gnk?e=aYcqx7

I've looked at gant charts to calendar view i'm not sure if i'm over complicating this or if its not possible.

 

Thank you

Resources