Creating Dynamic Calendar in Excel using Functions | SEQUENCE | WEEKDAY | SPIN BUTTON
HTML-код
- Опубликовано: 2 авг 2024
- In this video, we will learn how to create a dynamic calendar in Excel using functions like Sequence and Weekday.
Don't worry if your excel doesn't have a Sequence function, I will show you an alternate method as well.
Once this is created, use your creativity with Conditional Formatting to highlight various date-related events.
Check the practice file on the below link.
bit.ly/3G13M5A
00:00 Intro
00:45 Sequence function
01:37 Align First Date with correct Weekday
03:10 Basic Calendar Formatting
03:38 Conditional Formatting
05:05 Dynamic Month Selection
06:49 Formula without Sequence
08:14 Outro
Also, if you want to learn more check these videos
1 Min Excel: If you enjoy short videos check this section
• Shorts : Random
Excel: Check this playlist for Excel-related things
• Excel
Keyboard Shortcuts: Check this section to save some time in everyday excel work
• Excel Keyboard Shortcuts
Pivot Tables: Check this playlist for Pivot Table, Slicers, and Auto refreshing reports
• Pivot Tables
Power Query: Check the Power Query playlist for Data Preparation & its Automation
• Power Query
Power BI: Check the PowerBI related videos for Business Intelligence, Dashboard & Visualisations
• Power BI
Please subscribe to our channel and Follow us on other social media platforms for regular updates :
Tiktok vm.tiktok.com/ZSH28XEt/
Facebook / datacense
Twitter / datacense
LinkedIn / datacense
Instagram / datacense32
Great Job! Very easy to understand. I like the step by step demo. Also the alternative for those who don't use office 365. Thank you!
Thank you Richard for your lovely comment. Check our Dashboard playlist to learn more about interactive charts
Thank you. Your videos are very educational and helpful.
Thanks Prashanth .
only 27 likes...his save my job as administration...thanks many thanksn
Glad you found it useful. We need more people like you. Thanks for the lovely comment.
can you teach me how to select on date of dynamic calender to search data?
Can I add a separate spin button for the Year?
Yes that’s possible