Employee Vacation Planner and Tracker

With one page attendance layout to cover one full year, you can easily track and plan your employees vacation without switching to other worksheets to find their records. Included in this spreadsheet are custom codes with particular colors to ease you map different type of vacation/holiday.

To get started, you have to fill your company fiscal year start date and select your attendance observation period. You can customize four allocated vacation and holiday codes or leave it as it is. Then you can type your employees information.

There is a summary vacation worksheet that will help you to calculate your employees attendance monthly. Download and try the spreadsheet. And there is a commercial version where you can have it fully editable if you want to personalize it to meet your companys needs.