This feature really helps to make you flexible and add important milestone of your life that will also be highlighted.
Open the Downloaded file.
There are two views i.e. Monthly View and Yearly View are available in Calendar:
Go to “Holidays” tab and update the listing of holidays as per your requirement:
Now go back to related month’s tab, you would see that the Holiday dates are highlighted in color. Refer to “January” tab for example:
Yearly View is also available in the Calendar with tab “The YEAR 2021”. Holidays will be automatically highlighted as per the dates mentioned in the “Holidays” tab.
Hope you liked this article !!
Subscribe our blog for new amazing excel tricks.
Click below for some more interesting tricks and learning:
Random Rows Selector is an MS Excel based tool which can be used to pick random or stratified samples from a set of records available in the Excel. The tool is fully dynamic, it can support any data format in Excel.
Excel Files and Sheets Consolidator is an MS Excel based data consolidation tool which can be used to consolidate data from multiple Excel Files or Excel Sheets. The tool supports multiple configurations such as Sheet Name, Sheet Index, Header Row and Non-Blank column to help consolidating accurate data.
File Properties Tool is an MS Excel based tool which helps you to get File Name, File Path, Date Created, Date Last Accessed, Date Last Modified, Size (MB) and File Type properties of the files. You just need to browse the folder where your files are and click on ‘Get File Properties’ button.
Free File Renamer Tool – Quickly Rename files batch using Excel VBA Here is another help code and tool for programmers to rename files. You can use this tool for renaming all files available in…
VBA Code to list Files in Folder To work on multiple files through VBA programming, you need to have VBA code that can list files in a folder. Here is a simple code for you,…
File Manager tool is an Excel based tool which helps you to delete or move unwanted files from your system. It requires a source and destination folder (in case you want to move files). First it lists all the files available in the folder or sub-folders then you can select the action to be taken for each file such as Move or Delete. With a click of button, tool will take all necessary actions.