This is a semi automated calendar utility. You can enter any year after 1901. The days of the dates will be arranged automatically. However you need to input the holidays manually.
Published in Knowledge Base Tags: Excel Utility
Utility: Excel Calendar for Any Year
Updated on: 27.03.2020
This utility will help you to create a calendar of any year.
Note: This is a semi automated calendar utility. You can enter any year after 1901. The days of the dates will be arranged automatically. However you need to input the holidays manually.
You can also enter the local Holidays, Probable Holidays and Vacations as per your requirement. The entries of the holidays and vacations can be made haphazardly. The utility will automatically show the holidays and vacations day by day.
There are three types of calendar in the utility. One for holidays on all Saturday, another for holidays on 2nd & 4th Saturday and the last one for no holiday on Saturday.
The utility will also show different colours for different types of holidays. The colour codes are: Red= Holidays & Vacations, Brown= Local Holidays, Purple= Probable Holidays.
Prepared by: Sri Somnath Das, Judicial Department, Katwa, Purba Bardhaman.
For any query please ask here: Ask a Question