Plan your team’s annual leave for 2027 on one wall chart, online or in Excel. Bank holidays for England and Wales, Scotland, Northern Ireland or Ireland are already filled in, and each person’s allowance counts down as you book. No sign-up.
Updated November 2026 · dates from GOV.UK and Citizens Information
Free wall chart
Pick a leave type, then click a day to book it. With a mouse you can drag along a row to book a run of days, and clicking a booked day again clears it. Click a name to change that person’s allowance or working days.
Free Excel template
Prefer a spreadsheet you can keep on a shared drive? The template has the same layout as the planner above: a tab for each month with names down the side, weekends and bank holidays shaded, and a Team tab that adds up holiday booked and days left for everyone.
Free, no email needed. Want staff to request leave themselves, with approvals and different bank holidays for each office? Team Today does that inside Microsoft Teams, free for up to 10 people.
Built into the planner
England and Wales have 8 bank holidays in 2027, Scotland has 9, Northern Ireland has 10 and Ireland has 10 public holidays. Christmas Day and Boxing Day fall on a Saturday and Sunday: the UK moves the days off to Monday 27 and Tuesday 28 December, but Ireland has no substitute days.
| Date | Bank holiday | England & Wales | Scotland | N. Ireland | Ireland |
|---|---|---|---|---|---|
| Fri 1 January | New Year’s Day | Yes | Yes | Yes | Yes |
| Mon 4 January | 2nd JanuarySubstitute day | No | Yes | No | No |
| Mon 1 February | St Brigid’s Day | No | No | No | Yes |
| Wed 17 March | St Patrick’s Day | No | No | Yes | Yes |
| Fri 26 March | Good Friday | Yes | Yes | Yes | No |
| Mon 29 March | Easter Monday | Yes | No | Yes | Yes |
| Mon 3 May | Early May bank holidayMay bank holiday in Ireland | Yes | Yes | Yes | Yes |
| Mon 31 May | Spring bank holiday | Yes | Yes | Yes | No |
| Mon 7 June | June bank holiday | No | No | No | Yes |
| Mon 12 July | Battle of the BoyneOrangemen’s Day | No | No | Yes | No |
| Mon 2 August | Summer bank holidayAugust bank holiday in Ireland | No | Yes | No | Yes |
| Mon 30 August | Summer bank holiday | Yes | No | Yes | No |
| Mon 25 October | October bank holiday | No | No | No | Yes |
| Tue 30 November | St Andrew’s Day | No | Yes | No | No |
| Sat 25 December | Christmas DayNo substitute day in Ireland | No | No | No | Yes |
| Sun 26 December | St Stephen’s DayNo substitute day in Ireland | No | No | No | Yes |
| Mon 27 December | Christmas DaySubstitute day | Yes | Yes | Yes | No |
| Tue 28 December | Boxing DaySubstitute day | Yes | Yes | Yes | No |
| Total | 8 | 9 | 10 | 10 |
In Ireland, a public holiday on a weekend still counts: staff are entitled to a paid day off within a month, an extra day of annual leave or an extra day’s pay, but not automatically the next weekday off. Leave year running into 2028? Monday 3 January 2028 is a bank holiday across the UK, Scotland also has Tuesday 4 January, Northern Ireland and Ireland have St Patrick’s Day on Friday 17 March, and Ireland has St Brigid’s Day on Monday 7 February. The planner includes every 2028 date too. Dates from GOV.UK and Citizens Information, checked November 2026.
How it counts
Part-time staff
Click a name and untick the days that person doesn’t work. Those days can’t be booked, so someone on Monday to Wednesday never loses holiday to a Thursday they’d have off anyway. Give them a pro-rata allowance: 3 days a week is 16.8 days a year including bank holidays.
Work out a pro-rata allowance →Bank holidays
Most UK contracts say either 25 days plus bank holidays or 33 days including them. Choose “taken from the allowance” and each bank holiday on a person’s working day comes off their total, so a part-timer who never works Mondays isn’t charged for Easter Monday. In Ireland, public holidays always come on top of at least 20 days’ annual leave.
Check statutory entitlement →Everything else
A half day takes 0.5 off the allowance. Sick days and other absence, such as training or unpaid leave, show on the chart and in the year summary but leave the holiday allowance alone. The bottom row counts how many people are off each day and turns amber when you go over your limit.
This planner lives in your browser, so only you can see it. Team Today gives everyone the same view inside Microsoft Teams: staff request leave, managers approve it, and it syncs to Outlook and Google. Free for up to 10 people.
Yes. There is no sign-up and no limit on the number of people. The planner runs in your browser and saves there automatically.
In this browser, on this device. Nothing you type is sent to Team Today. Clearing your browser data deletes the planner, so use Back up to save a copy as a file, and Restore a backup to pick it up again on another computer.
England and Wales have 8 bank holidays in 2027, Scotland has 9, Northern Ireland has 10 and Ireland has 10 public holidays. Christmas Day and Boxing Day fall on a Saturday and Sunday: the UK moves the days off to Monday 27 and Tuesday 28 December, but Ireland has no substitute days. The full list of dates is above.
Yes. Switch the planner to Ireland and it uses Ireland’s 10 public holidays for 2027, including St Brigid’s Day and the June and October bank holidays. One switch covers the whole planner. If your offices are in different countries, Team Today gives each office its own holidays.
Yes. Print this month gives a one-page landscape chart for the month on screen. Print the year prints all twelve months, one per page, followed by the year summary. Leave types print as letters as well as colours, so a black and white printer works too.
Yes. Download the free Excel template for a January to December 2027 leave year or an April 2027 to March 2028 one. Pick your country once and every month tab shades the right bank holidays. It works in Excel and Google Sheets, with no macros. To take what you’ve entered online into a spreadsheet instead, use Export to CSV.
Yes. Set the leave year to start in April and the planner runs from April 2027 to March 2028, with the 2028 bank holidays included. Any start month in 2027 works.
Click the person’s name and untick the days they don’t work. Those days are greyed out so leave can’t be booked on them, and if bank holidays come out of the allowance, only the ones on their working days are deducted. Give them a pro-rata allowance, for example 16.8 days including bank holidays for 3 days a week. The pro rata holiday calculator works it out for any pattern.
The UK statutory minimum is 5.6 weeks a year: 28 days for someone working 5 days a week, and bank holidays can count towards it. Many employers offer more, commonly 25 days plus bank holidays. In Ireland the minimum is 4 working weeks (20 days for a 5-day week), with public holidays on top. The holiday entitlement calculator covers UK part-timers, starters and leavers.
Holiday dates: gov.uk: UK bank holidays; Citizens Information: public holidays in Ireland. Entitlement: gov.uk: holiday entitlement rights; ACAS: checking holiday entitlement; Citizens Information: annual leave.
Dates checked November 2026. This planner is a planning aid, not legal advice.
Free calculators
Work out the right allowance for each person before you put it on the planner, with the working shown at every step.
The full statutory calculation in days or hours, including starters and leavers.
Part-time entitlement with bank holidays handled fairly, including for staff who never work Mondays.
Agenda for Change entitlement by service length, in hours for part-time and shift staff.
Track a whole team’s leave in Microsoft Teams, with approvals and a live team planner. Free for up to 10 people.
Leave requests, approvals and a shared team calendar, synced to Outlook in seconds.
