Free Excel template
Free vacation planner template for Excel
Get the whole year’s vacation on one sheet, with one row per employee and one column per week. The template counts the vacation days and shows who is away when.
Excel file (.xlsx) · Opens in Excel, Google Sheets and LibreOffice · No sign-up
What’s in the vacation planner
The vacation planner is made for businesses that want one shared overview of vacation instead of requests in emails, messages and personal calendars.
The whole year in weeks
One row per employee and a column for each week from 1 to 52. Enter the year, and the date of each week’s Monday shows under the week number.
Vacation, time off in lieu and sickness
Enter V, T or S in the week. A code on its own is a whole week, and a code with a number, e.g. V2, is two days. The weeks are coloured by type.
Vacation days used and left
Enter the vacation days the employee has available. The template counts the planned days and shows how many are left.
Who is away when
At the bottom you see how many employees are away each week, so overlaps and thin staffing are easy to spot.
Ready to print
Prints on two landscape A4 pages – weeks 1–26 and weeks 27–52 – with the names on both. A sheet with instructions is included.
How to fill in the template
- 1
Enter the year
The week numbers and the date of each week’s Monday fill in by themselves.
- 2
Add the employees
Enter the names and the vacation days each employee has available in the period.
- 3
Mark the days off
Enter V for vacation, T for time off in lieu and S for sickness in the week – with a number if it’s only some of the days.
- 4
Keep the plan up to date
Update the plan when an arrangement changes, and let the people affected know.
Vacation entitlement and planning
A vacation plan is easier to put together when you know the main rules that apply to you.
Vacation entitlement varies by country
In the EU, every worker is entitled to at least 4 weeks of paid annual leave under the Working Time Directive. Many countries give more by law, and contracts and collective agreements can add further days.
How leave is earned, when the leave year starts and how long unused days can be carried over also differ from country to country. Check the rules that apply to your business, and enter each employee’s available days in the template.
Plan the busy periods early
Summer and the holidays are when most people want time off at once. Notice periods for requesting and approving vacation depend on your country and your agreements – but the earlier requests are collected, the easier it is to make the staffing add up.
A simple vacation process
The plan works best when everyone knows how it’s used:
- Agree where employees send their requests, and who approves them.
- Make it clear when a vacation is requested, pending or approved.
- Look at staffing and critical tasks before approving several requests for the same time.
- Update the plan when an arrangement changes, and let the people affected know.
A vacation plan supports your company’s vacation policy and employees’ vacation balances – it doesn’t replace them. Read more in our guide to a vacation overview for your whole team.
This is general information, not legal advice. Always check the rules in your country and any agreements that apply to your business.
When the spreadsheet no longer does the job
A vacation plan in Excel gives a good overview, as long as one person keeps it up to date. That’s usually where it breaks.
- Requests come in by email, text and chat, and someone has to type them into the plan.
- The plan doesn’t show whether a vacation is requested, pending or approved.
- Employees only see the plan if it’s shared – and then it may be an old version.
- Vacation days used and left are only right if everything was typed in correctly.
- Vacation isn’t connected to the shift schedule, so you have to remember who is away.
How Weekplace does the same job
- Employees record vacation, sickness and child’s sick day themselves – vacation ahead of time, too.
- Turn on approval, so a manager approves or rejects the vacation.
- Everyone gets a shared vacation overview of who is away when.
- Vacation shows right in the shift schedule, and an employee on vacation can’t be given a shift.
- Vacation and absence are kept in the same place as working time.
See how vacation and absence work in Weekplace’s HR app.
Pay once
€199
one-time · excl. VAT
The same price whatever the number of employees. Pay once and use Weekplace forever.
- Time tracking, shift scheduling, vacation and absence
- Unlimited employees
- No subscription and no monthly payments
No payment to get started
Frequently asked questions about vacation planners
How much vacation are employees entitled to?
It depends on the country. In the EU every worker is entitled to at least 4 weeks of paid annual leave, and many countries, contracts and collective agreements give more. When the leave year starts and how leave is earned also vary, so check the rules that apply to you.
Why does the vacation planner follow the calendar year?
Most businesses plan staffing in calendar weeks. If your leave year runs differently, the plan can cover parts of two leave years. Enter the vacation days the employee has available in the period the plan covers, e.g. from the balance in your payroll system.
Can I record half vacation days?
The template counts whole days: V for a whole week and V1–V4 for one to four days. Half days or extra days off under a contract can be noted separately, e.g. in an extra column.
Can I use the vacation planner in Google Sheets?
Yes. The template is an ordinary Excel file (.xlsx) that opens in Excel, Google Sheets and LibreOffice.
Do you also schedule shifts? See shift scheduling in Weekplace, where vacation shows right in the schedule.
More free templates: timesheet and shift schedule – or see all templates.