Wish you very happy new year 2019. May the New Year bring you delight, health and happiness in all your endeavors. To learn something grate and interesting stuffs in excel, subscribe to excelhub.org. In the year 2019 my target is to publish all 450+ excel functions and many more things here.
Excel Calendar for 2019
In this post i will explain you how to use this excel calendar for 2019 or for any year.
How to use Excel Calendar for 2019
The calendar is prepared using excel VBA. Therefore you need to enable macros to use calendar.
You can use this for any years by changing the year. The calendar will be updated automatically. However the holidays needs to be updated for other years since i have updated this only for 2019.
We can add holidays, events, meetings etc, in calendar. to add this double click on a particular date. It will show the form to add details.
There are four categories of events defined in this and you have to select the appropriate one. You can write up to 5 lines for each day events.
Based on the category selected the dates will be highlighted in the calendar with color codes. When you select a date the details will be updated in the right side box provided.
You can update, edit or delete the events in the calendar by double clicking on the calendar.
I hope this calendar is useful for you. Please comment in case if you have any suggestions or queries on this.