Create a Dynamic Monthly Calendar in Excel 365 or Online | Dynamic Calendar Excel Formula
Download the featured file here: https://www.bluepecantraining.com/wp-...
In this video I demonstrate how to create a dynamic monthly calendar in Excel 365 or Excel Online. The calendar uses the following functions DATEVALUE, WEEKDAY and SEQUENCE. Using conditional formatting the calendar highlights bank holidays and the current date.
00:00 Introduction
00:22 Create the drop-downs for month and year
01:58 Use DATEVALUE to return the first day of the selected month
03:15 Use WEEKDAY to return the weekday number of the first day of the selected month
03:58 Use SEQUENCE to populate the calendar with dates
06:40 Combine all formulas into a single formula
07:53 Format the calendar
08:55 Grey out dates that don't belong to the selected month
11:28 Display bank holidays in a different colour
14:01 Highlight the current date
------------------------
Watch video Create a Dynamic Monthly Calendar in Excel 365 or Online | Dynamic Calendar Excel Formula online without registration, duration hours minute second in high quality. This video was added by user Chester Tugwell 16 January 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 46,75 once and liked it 59 people.