How to Make an Interactive Calendar in Excel Automatic and Dynamic Calendar

24,496 views

Published on Jul 2, 2024

About :

🟢 LEARN EXCEL WITH ME IN THE COMPLETE EXCEL COURSE WITH CERTIFICATE: http://excelentejoao.com.br/sejaexcel... In this Excel video lesson, I will show you how to make a dynamic and interactive calendar in Excel that changes year and month automatically from your choice. To be able to create the calendar in the Excel spreadsheet, we will need to use important Excel tools and features such as the date function together with the procv function, the endmonth function, the day.of.week function, conditional formatting and DropDown List. Excel's DATE function is used to combine three separate values to form a date. So, here you need to have three important pieces of information, the day, the month and the year. The Date function takes this information, puts it together, and transforms it into the standard date display. The VLOOKUP function is a search function in Excel, just like the procX, procH functions or even the combination of the index and match functions. Let's use the procv function in conjunction with the data function to search for the reference number of the month selected in the check box. Basically, the VLOOKUP function is used to find items in a table or a range by row. For example, searching for the price of an auto part by part number or finding an employee's name based on the employee ID. The ENDMONTH Function works with dates in a spreadsheet, based on a date it returns another specific date. Briefly, the ENDMONTH function is used to return a current date, before or after an indicated date. This date that the function returns is the last date of the month. It simply serves to return the last date of a month, based on another date indicated and the number of previous or subsequent months indicated therein. The day.of.week function in Excel will help us know which day of the week the date we selected begins. For example, January 1, 2024 begins on which day of the week? The answer is Monday, so the function will not return the number 1, which refers to Monday. Conditional formatting makes it easier to highlight certain values or make certain cells easy to identify. This changes the appearance of a range of cells based on a condition (or criteria). You can use conditional formatting to highlight cells that contain values that meet a certain condition. Or you can format an entire range of cells and vary the exact format as each cell's value varies. We can paint the entire Excel row with conditional formatting, as well as painting just a specific cell. And the interesting thing is that it is possible to automatically paint Excel cells. Drop-down list or option box is an excellent tool in Excel that we can use to help us fill in repetitive information. So, as in the tutorial we have to keep writing the same thing all the time, be it months or years, we created a list of options in Excel to make the work easier and to save time on a daily basis. #ExcelenteJoão #Excel #Dashboard

vidoe Comments

Trend Videos