- File format
- Excel (.xlsx)
- Works with
- Excel 2016 or newer
Who is away, and when - for teams of up to 40 people. One row per person, one column per day, colour codes for holiday, sick leave, remote days and public holidays.
It is a shared spreadsheet, not an HR system: there is no approval workflow. For most small teams that is precisely the point.
Why teams like it
- The whole year on one scrollable sheet, frozen names on the left
- Remaining allowance per person, calculated live
- Overlap warning: the day turns orange when more than a set number of people in the same team are away
- Public holidays for 30 countries on a separate, editable tab
- A monthly summary page you can paste into a payroll e-mail
Set-up in five minutes
- List your people and their yearly allowance on the Team tab.
- Choose your country on the Holidays tab, or paste your own dates.
- Start typing
H,SorRinto the calendar.
It is a shared spreadsheet, not an HR system: there is no approval workflow. For most small teams that is precisely the point.
Gallery
-
Leave calendar - summary
