An Excel-based any Year Business Holiday, Training and Absence Planner, featuring Julian Calendar with UK Bank Holidays, ISO Week numbers, Week Days and Dates. The Holiday Planner allows you to plot Holiday Days, Training Days and Absence Days against an unlimited amount of Employees, collating the Monthly statistics into a simple YTD Summary. The Calendar view gives you a detailed view by Employee of all of the Holiday Days, Training Days and Absence Days booked in a Grid format for the selected Year. Full Days Booked are shown as a solid Fill Colour and half-days are shown as shaded. Options allow you to show or hide Bank Holidays and Weekends on the "Calendar" Worksheet or the individual Calendar Month Worksheets. Weekend Days can also be changed, for example, for UAE (United Arab Emirates) "Friday" and "Saturday" can be set as Weekends instead of "Saturday" and "Sunday". They can be displayed on the "Calendar" Worksheet and individual Calendar Month Worksheets

Excel 2010 or Excel 2013

Features include:
Perpertual Julian Calendar - change the Calendar to any Year & everything adjusts to fit
A YTD Summary Worksheet collates all of the Code statistics for all of the Employees
A Calendar Worksheet details all of the Holiday Days, Training Days & Absence Days in a single Calendar Year Grid
The Calendar Worksheet can start on a Sunday or a Monday (ISO Weeks will only be shown correctly when the start of the Week is set to Monday)
Individual Calendar Month Worksheets simplify the booking process
UK Bank Holidays are automatically populated using Conditional Formats
The Holiday Planner automatically adjusts to handle the Leap Year in February
The Holiday Planner features ISO Week Numbers, Day of Week & Date
Conditional Formatting automatically Formats the Codes, Weekend Days & UK Bank Holidays
Conditional Formatting can highlight Section Headers in the Calendar Month Worksheets
The Holiday Planner captures half Days for all Codes
The Calendar is easy to setup and adjust for a new Year
The Holiday Planner background can be changed quickly by modifying a single Cell
Unlimited Employees - simply drag down the Cells on the YTD Summary Worksheet (Planner allows 250 Employees without a minor Formula modification
You can choose different Days for the Weekend, for example in UAE (United Arab Emirates) "Friday" and "Saturday" can be set as Weekend Days
You can lock the Planner down using a Password making it Read-only for your employees
You can Hide the highlighting for the Bank Holidays & the Weekends on the Calendar and the individual Calendar Month Worksheets
Codes are case insensitive meaning the Workbook interprets upper and lowercase letters as being the same
The Workbook does not use any VBA & the Formulas used are very simple to understand
Holiday Planner can now be used to track 'Absence Hours' or 'Hours Worked' using a Drop-down option on the 'YTD Summary' Worksheet. You can enter any positive or negative Value in any of the Calendar Cells to record the Hours
You can now begin the Calendar in a different Month ie. April. This rotates any Worksheets 'Years' that are not within the current Year to be the next Year ie. April 2016
This means that you can track Holidays, Training Days etc. from April 2016 through to March 2017 - because there is no VBA Code , you will need to manually reorder the Worksheets so that they are in the sequence that you require and all of the Formula will pick up the changes

Use the links above to purchase Holiday Planner or read online documentation and watch a video of Holiday Planner on YouTube. You can also Share this article to Twitter, Facebook or Google+ using the links at the bottom of this page