Tag Archive: Calendar

Articles sur le thème : Calendar

How to make automatic calendar in Excel

Creating a new calendar each month is a waste of time, but many people do as they think they need to rebuild it to get correct weekends and public holidays. But in fact, with few formulas, 2 conditional formatting rules, 1 dropdown list and 5 lines of VBA code, you can create an automatic calendar. …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/how-to-make-automatic-calendar-in-excel/

Explanation of the VBA code for the calendar

What is the value of the dates in column 30, 31 and 32

Each lines of the VBA code for the automatic calendar explain in detail.

Permanent link to this article: https://www.excel-exercise.com/explanation-of-the-vba-code-for-the-calendar/