Holiday & Annual Leave Tracker 2027 (Excel)

Know who's off and how much leave is left.

Everyone's leave in one place for 2027. Days are counted for you, skipping weekends and public holidays, with a colour-coded planner showing who's off each day. No macros.

WHAT IT DOES

• Up to 25 staff and 300 leave requests

• Days counted with weekends and public holidays skipped (NETWORKDAYS)

• Half days count as 0.5

• 6 leave types; you choose which come off the allowance

• Allowance, carry-over, booked, pending and remaining for everyone

• Approved, Pending and Declined requests, with clash warnings

• Colour-coded month planner with staffing warnings

• Dashboard: booked, remaining, pending, off today, coming up and leave by month

• US federal holidays for 2027 included, easy to replace with your own (UK bank holidays, etc.)

WHO IT'S FOR

Managers, team leads, small businesses and HR, or anyone planning their own time off in 2027.

GOOD TO KNOW

• Works in Microsoft Excel: Microsoft 365, Excel 2010 or later on Windows, and Excel for Mac

• Normal .xlsx file: no macros to enable

• One-off payment, instant download

Made by Lee at Sheet Leveller, whose tutorials have been watched 6.3 million times on YouTube.