2027 PTO Planner (US) – federal holidays, team overlaps and PTO balances | Excel

Who is out next week? Will the sales team still have enough people in early August? Who has booked no time off for the summer, and who will end the year with a negative PTO balance? The 2027 PTO Planner (US) answers these questions in one Excel workbook, with no macros, built for owners and managers of small businesses (5 to 50 people).

For businesses

This workbook is sold to businesses for professional use: owners, managers, office managers and HR staff of small businesses.

What you get

• PTO-Planner-2027-US.xlsx – the blank workbook, 10 tabs, native Excel formulas:
  • How to use: the 10-minute start, color key, limits, dated official sources.
  • Settings: working days of the week, plan year (a 'TO VERIFY' cell: set by your PTO policy), summer period, the most people off at once per team (6 teams) and overall, absence types deducted from the PTO balance or not.
  • Holidays: the 2027 federal holidays with the observed dates published by OPM (June 18, July 5 and December 24, 2027, plus Friday, December 31, 2027, New Year's Day 2028 observed), read on October 18, 2026, an 'observed by the company' Yes/No column, and 12 rows for your own company holidays.
  • Team: up to 50 people; carried over and PTO for the year (entered from your own PTO policy), taken, booked ahead, pending, remaining, remaining if pending requests are approved; alerts for a negative balance, a high unbooked balance, nothing booked in summer, a duplicate name.
  • Requests: up to 400 requests; days counted (holidays off and half days deducted), status Requested / Approved / Declined / Canceled, checks: end before start, overlap (same person, same dates), team clash (peak number off in the team over the request compared with its limit), overall limit.
  • Calendar: the month of your choice, one row per person (P approved PTO, ? pending, H holiday, WE weekend), people off per day in total and per team, a '!' alert on days above a limit.
  • Year view: a heat map of people off over the 12 months, days above a limit.
  • Long weekends: the 2027 bridge days worked out from your week and the holidays you observe (Monday to Friday, every federal holiday observed: Friday, November 12 and Friday, November 26, 2027), PTO days to book, days off in a row, people already out.
  • Dashboard: 12 indicators, time off per month and per team, a chart, a 'To do' list of pending or flagged requests.
  • Days: the helper tab for the 365 days of 2027 (do not edit).
• PTO-Planner-2027-US-SAMPLE.xlsx – the same workbook filled with a fictitious sample: 12 people, 3 teams, 40 requests, including 2 deliberate team clashes and 1 overlap, 3 pending requests. Every calculation is visible before you type your own data.
• PTO-Planner-2027-Guide-US.pdf – a 13-page Letter guide: what the planner does and does not do, the 10-minute start, settings, the 2027 holidays and their sources, requests and checks, calendar and team clashes, bridge days, balances and alerts, dashboard, Google Sheets and printing, FAQ, sources and license.

What it does not do

It does not set PTO rules: the U.S. Department of Labor states that the FLSA does not require payment for time not worked, such as vacations or holidays; PTO is a matter of agreement between employer and employee, and state or local rules may apply. You enter each person's carry-over and PTO from your own policy. Private employers choose which holidays they observe. It does not replace payroll software or employment advice. It only holds the 2027 schedule.

Dated official sources

2027 federal holidays and observed dates, and December 31, 2027 from the 2028 schedule: U.S. Office of Personnel Management (opm.gov, Federal Holidays), read on October 18, 2026. Payment for time not worked: U.S. Department of Labor, Vacation Leave, read on October 18, 2026.

Quality

No macros, no add-ins, no connections: your data stays in your file. Standard functions available in Excel 2016 and in Google Sheets (NETWORKDAYS.INTL, COUNTIFS, SUMIFS, SUMPRODUCT, INDEX, MATCH, IFERROR); no XLOOKUP, LET, FILTER or dynamic arrays. Drop-down lists, input validation, frozen panes, filters, conditional formatting, Letter print areas. Recalculated in Excel with 0 formula errors, on the sample and on the blank workbook, and checked against an independent recalculation (33,258 checks, 0 differences). Built for Excel. The functions used also exist in Google Sheets, but the import has not been tested: if you import it, check the flagged clashes, the drop-down lists, the calendar, the colors and the chart (the guide lists these checks).

Business license: unlimited use within the purchasing business · resale and redistribution prohibited