Create a Dynamic Monthly Calendar in Excel 365 or Online | Dynamic Calendar Excel Formula

Microsoft Excel Tips and Tricks

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.

Credit Chester Tugwell

Please support our Sponsors here :