Learn DATE functions by building THIS Calendar

This is one of the best Calendars I've used so far. The main idea of it is to highlight the most important events of the year and overview them on a single A4 page. In this tutorial you will learn how to build such a calendar yourself and along the way we will dig into date functions such as =DATE(), =EDATE(), =EOMONTH(), =TODAY() etc, and also we will use some interesting to automatically highlight days within the calendar. Enjoy! 📚FOLLOW ALONG! LINK WITH THE WORKBOOK: https://www.dropbox.com/scl/fo/vvfpxm0xilpbva9arjozb/AHoZiEqe3GmhfvVzzsk9Tqg?rlkey=n0hcik3wm3i5etow8rnn1n7yy&st=cz3lgqh7&dl=0 🕓TIMESTAMPS: 00:00 Introduction 00:43 Building month column and weeks row. 02:14 Getting the name of the first day of each month 04:12 Getting the correct number of days for each month of the year 07:55 Converting the days of the calendar to the correct date format 12:28 Styling the calendar 14:03 Using Conditional formatting to highlight days in calendar 15:43 Adding the "big rocks" to the calendar 💻RELATED VIDEOS: - Playlist with all my tutorials on Excel: https://youtube.com/playlist?list=PL2-FQQ5rWXBoWeO5g2KfjeBIjzbXCNAv_&si=XPmcvjkqMi6XCY6Y - Playlist with all my tutorials on Power Query: https://youtube.com/playlist?list=PL2-FQQ5rWXBom-pX9Pg3uPnHOrd5QBJ72&si=XvwrGJCnchjTfdRR