July 03 2009
Manage Staff Holiday (Vacation), Sickness, Training and more with this Excel Spreadsheet Planner

The Excel Holiday Planner is a simple yet powerful tool to aid in the management and administration of staff leave. At dhxsoft, we understand our customer's needs and know that different businesses operate their staff leave in different ways. Therefore not only will the planner track staff holiday (vacation), sickness and training but it also allows you to define up to 10 leave codes of your own (e.g Maternity leave). We can also adapt to the needs of your business by creating custom planners to match your annual leave year cycles, for example from September to August.

This solution has been developed with the user in mind: acknowledging that computer users prefer clean, easy to learn, intuitive interfaces. This is why the Excel Holiday Planner has been written in Microsoft Excel; the user has sufficient knowledge of Excel so that they don't need to learn new skills in operating the program. Unlike web based systems, the planner can be put anywhere on your computer network, be password protected and is completely under your control.

Over 400 businesses are using the Excel Holiday Planner, why not try it to see what it can do for you?

Staff Planner Product Features
The Excel Holiday Planner has the following features which give you total control over how you can manage staff leave:
  • Record annual leave as full or half days ("Days" version of the planner)
  • Record sickness as full or half days ("Days" version of the planner)
  • Record training as full or half days ("Days" version of the planner)
  • Record all leave by hours ("Hours" version of the planner)
  • Can be used in any country due to the ability to customise the national holiday dates
  • Protectable with a password to prevent unauthorised access
  • Add up to 10 of your own custom codes
  • See at a glance statistics of all leave data (including custom codes)
  • Create individual leave reports (including custom codes)
  • Create a batch of individual reports and save them as a seperate file.
  • Create a monthly report to show selected staff leave each month.
  • Print out the planner using the monthly report.
  • Create a group leave report to show selected staff leave across a date period.
  • Choose to show or hide weekends
  • Sort the planner by name or department
  • Add comments to all entries
  • Modify the colour scheme to suit your needs
  • Customised for Microsoft Excel 2007.
The planner is written in Microsoft Excel and is compatable with all versions except for Excel 97 and all version for the Mac.



Excel Holiday Planner

Save time and money managing staff leave
  • The calendar view allows you quickly and easily see who is off and when.
  • Reduce the risk of human error when calculating leave - all calculations are automatically made by the planner.
  • Simply enter codes onto the planner to indicate the type of leave to take. This takes a matter of seconds.
  • No need to install any additional software - Only Micorosft Office is required.
Group Staff Together
  • Group staff together using the department field so that reports can be narrowed to specific areas, allowing you to differentiate between your staff.
Produce detailed reports
  • The planner has a built in reporting function that allows you see each member of staff's leave details.
  • Customize the report to include specific types of leave, including your own custom codes.
  • Limit the report by specific dates.
  • Create a "bulk" report that will create individual reports for a given number of staff and save them to an external file.
  • Create a "monthly report" to show staff leave for a given month on a calendar that can be easily printed out.
Customise the staff planner to suit your business needs:
  • Edit the national holiday dates that are shown on the planner to match your country.
  • Choose whether to show or hide weekends.
  • Add your own leave codes which are fully tracked by the built in statistics.
  • Sort the data by various filters e.g name, department, leave taken etc.
  • Hide columns that are not relevant to the way you run your business.

Want to learn more?

Use the form below to download a demo of the Excel Holiday Planner and try it for free today.

Download Demo / Purchase

Use the form below to determine the planner that is right for your business:


Dates to cover on the planner
Number of staff to show on planner
Measure time in Days or Hours: