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 Example File

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