Dynamic Calendar with Single formula connected with Task List || No VBA Used
PK: An Excel Expert PK: An Excel Expert
263K subscribers
188,809 views
0

 Published On Mar 13, 2022

#TaskList #ExcelCalendar
Hello Friends,

In this video, you will learn how to create a Dynamic Calendar in Microsoft Excel. We have used a Single formula to create this Dynamic Calendar. We have displayed two form control Spin buttons to change the Month and Year of the calendar. On the Right-hand side, we have displayed the Filtered Task List. We have used the Filter function to show the Filter task list. We have used multiple conditional formatting to hight the days in Calendar and Red, Amber, and green text in Task List according to the status of the task.

Download the practice file from the below link:
https://www.pk-anexcelexpert.com/dyna...

Learn and download our interactive Excel dashboards free of cost-
   • Excel Dashboards  

Download the Free Project Management Dashboard
https://www.pk-anexcelexpert.com/exce...

Download the Calendar Control in VBA from below link
https://www.pk-anexcelexpert.com/full...


Download our free Excel utility Tool and improve your productivity:
https://www.pk-anexcelexpert.com/prod...

See our Excel Products:
https://www.pk-anexcelexpert.com/prod...

Visit to learn more:
Chart and Visualizations: https://www.pk-anexcelexpert.com/cate...
VBA Course: https://www.pk-anexcelexpert.com/vba/
Download useful Templates: https://www.pk-anexcelexpert.com/cate...
Dashboards: https://www.pk-anexcelexpert.com/exce...

Watch the best infographics and dynamic charts from below link:
   • Dynamic Graphs  

Learn and free download best excel Dashboard template:
   • Excel Dashboards  

Learn Step by Step VBA:
   • VBA Tutorial  


Website:
https://WWW.PK-AnExcelExpert.com

Facebook:
  / pkanexcelexpert  

Telegram:
https://t.me/joinchat/AAAAAE2OnviiEk5...

Pinterest:
  / pkanexcelexpert  

LinkedIn:
  / pk-anexcelexpert  

Instagram:
  / pkanexcelexpert  

Visit our Amazon Store
https://www.amazon.in/shop/pkanexcele...

show more

Share/Embed