How to make Dynamic Calendar with Holiday List in Google Sheets
Welcome to this Channel! This video is about How to make dynamic Calendar with Holiday or Event List in Google Sheets. Step-by-Step Guide to make Dynamic Calendar with Holiday or Event List in Google Sheets.
Chapters:
0:00 Intro
0:49 Create Sheets and make Data
1:57 Dropdown list for Years
2:30 Formatting and Creating Single Month Calendar
4:22 Applying formula for Month Name
5:32 Applying formula for Days of Months
7:10 Make 12 Months Calendar
8:30 Importing Holiday or Events from another Sheet/tab
9:40 Tables for Holiday or Event List
10:29 Applying Conditional Formatting for Extra Month's Days
13:50 Red Color applying for Week Off
14:25 Highlighting Holidays/Events in Calendar
17:53 Checking or Testing Holidays
18:38 Outro
++++++++++++++++++++++++
If you want to learn more advanced topics in Excel, Google Sheets, Google Apps Script, Google Data Studio, SQL, Big Query, Tableau, MS PowerBI, Dashboard Creation, Data Visualization then please subscribe this channel and press bell icon 🔔 for notification:
/ @tenpowerten
Follow on Social Media:
Website: https://bit.ly/4cHb8dt
Facebook: https://bit.ly/3MnQeW3
Instagram: https://bit.ly/4dEJHCt
Linkedin: https://bit.ly/3T5VHEM
Telegram: https://bit.ly/3T7pc90
2nd Youtube Channel: https://bit.ly/4fWdSql
#googlesheets
#calendar
#dynamic
#googlesheetstips