Employee Holiday & Leave Tracker Spreadsheet – Annual Leave, Sick Days & Remaining Days for Up to 15 Staff (Excel + Google Sheets)
Know who is off and how many days are left.
What's inside:
Team: up to 15 employees with allowance and days carried over
Leave: up to 500 lines with automatic working days and a half-day override
Dashboard: holiday taken, remaining and sick days per person, plus team totals
What you get:
Employee-Holiday-and-Leave-Tracker-Spreadsheet.xlsx – the blank tracker
Employee-Holiday-and-Leave-Tracker-Spreadsheet-EXAMPLE.xlsx – filled with sample staff
The calculations were checked against an independent model.
Bank holidays are not removed automatically; use the override column. A record-keeping tool. Check your contracts and current UK holiday rules. Not legal or HR advice.
Instructions are on the Start Here tab.
Works in Microsoft Excel 2016 or newer (Windows and Mac), Excel for the web, and Google Sheets (upload the .xlsx to Google Drive and open it with Google Sheets). No macros.
This is a digital download. No physical item will be shipped. For personal use only.