Holiday planner 2027 for the whole team
An annual overview for 25 people with a holiday account per person and a sheet with the nationwide public holidays for 2027.
- No sign-up
- No newsletter
- Free to use
What is in the template?
Ready to use, with formulas, sample data and a legend.
- 25 people times twelve months on one sheet
- Entitlement, taken and remaining per person automatically
- A sheet of its own with the nine nationwide public holidays for 2027
- The first column and the header row frozen
- Notes on sections 3, 5 and 7 of the Federal Holiday Act on the sheet
When does the template fit?
Ideal as an interim solution or for small teams, with clear limits.
- Annual planning in autumn, before the requests come in
- An overview of bottlenecks in school holiday periods
- A basis for the conversation about remaining holiday
The spreadsheet does not see two requests for the same week.
An annual sheet shows who has taken how many days, but not who is away at the same time. MetronHR checks the request against the team calendar, warns about overlaps, calculates the entitlement pro rata and reminds people about remaining holiday before it lapses.
| Excel template | MetronHR | |
|---|---|---|
| Upkeep | Manual upkeep | Automatic calculations |
| Approvals | No workflows | Approval workflow |
| Reminders | No reminders | Reminders |
| Team | Copy again for every employee | One central source for the whole team |
Frequently asked questions
Answers on usage and legal aspects.
Question not answered here? Every step is explained in the help centre.
Send us a messageWhich public holidays apply nationwide in 2027?
Nine: New Year's Day on 1 January, Good Friday on 26 March, Easter Monday on 29 March, Labour Day on 1 May, Ascension Day on 6 May, Whit Monday on 17 May, German Unity Day on 3 October and the two Christmas holidays. Easter Sunday falls on 28 March in 2027. Corpus Christi, All Saints' Day, Assumption Day, Reformation Day and Epiphany apply only in individual states and are therefore not on the sheet.
How do I convert the holiday entitlement for part-time work?
Via the number of working days a week, not via the hours. Anyone working three days instead of five has three fifths of the entitlement. So 20 working days on a five-day week become twelve. If the number of working days changes during the year, each period is calculated separately.
How much leave is there in the year of joining or leaving?
One twelfth of the annual leave for every full month of employment, where the six-month qualifying period has not yet been met or where the employment ends in the first half of the calendar year (section 5 BUrlG). Anyone who has met the qualifying period and leaves in the second half of the year is entitled to the full annual leave.
When does remaining holiday from 2027 lapse?
In principle on 31 December 2027 (section 7 (3) BUrlG). Carrying it over until 31 March 2028 requires urgent operational or personal reasons. Under the case law of the Federal Labour Court, however, leave lapses only if the employer has previously pointed out the impending lapse and asked the employee to take it.
Templates are a start. MetronHR is the answer.
When Excel reaches its limits in a team, MetronHR takes over the process. Try it free for 14 days.
- No credit card required
- Ready quickly
- Cancel monthly
- Full access to every feature
Ready in 5 minutes, no credit card