One row per request — who, what kind, from, to — and the working days are counted for you, weekends out. Balances per person against an annual allowance. Pro excludes public holidays, adds an approval status, a Balances sheet per person and type, and a month calendar showing who's off on which day. No macros.
200 request rows: person and type from dropdowns, from and to, working days counted with weekends excluded, a request ending before it starts flagged red. Free: twelve people with allowances and their annual, sick and other days and what's left, on the same sheet.
Per person × leave type for the year on Setup, approved only; left against the allowance (red when overdrawn, yellow at three or fewer), % used with bars, team totals, pending requests and days.
Type the 1st of any month: people down the side, days across, a letter per approved day (A annual, S sick red, U, P, O), weekends and holidays shaded, days off per person and people off per day.
Year, team with allowances, leave types with letters, statuses, forty holidays.
Eight formulas explained: the weekend arithmetic without NETWORKDAYS, the holiday subtraction, the five-way COUNTIFS behind each calendar cell, counting letters with SUMPRODUCT(LEN()).
Every workbook is recalculated in LibreOffice and by a second, independent formula engine on the sample data; the totals are compared with numbers worked out outside any spreadsheet, and every formula cell is scanned for errors. We don't run Excel itself on the build machine, so this says built for, not tested in — open the live preview to see the numbers the formulas produce.
What that means app by app: in Google Sheets, in Apple Numbers, in LibreOffice Calc.
The home page and its CSS — enough to publish a one-pager. A credit link stays in the footer.
Every page, the Pro-only pages, the source files, no attribution, and 12 months of updates and email support.
Use it for unlimited personal and commercial purposes, including client work.
Do not resell the spreadsheet itself, alone or in a bundle.
A leave tracker is a log and two questions: how many days does this request cost, and how
many does each person have left. The log counts working days for you — calendar days minus
Saturdays minus Sundays, done with WEEKDAY arithmetic rather than NETWORKDAYS so the
result is the same in every app and the arithmetic is visible. Balances read the log with
SUMIFS per person and type, for the year on Setup, so last year’s rows can stay.
Pro subtracts the public holidays on Setup from each request, adds a Status column so only Approved requests count (Pending stays yellow, Declined is struck through), and moves balances to their own sheet with % used and team totals. The Calendar sheet is the one a manager wants: type the 1st of any month and see people down the side, days across, a letter per approved day, weekends and holidays shaded, and how many people are off each day.
Each calendar cell is a five-way COUNTIFS — this person, this type, approved, from ≤ day,
to ≥ day — nested once per type so the first match gives the letter. Counting the letters
in a row uses SUMPRODUCT(LEN(…)), because every letter is one character and every empty
result is zero; it’s the portable way to count non-empty formula results.
The build recalculates both workbooks in LibreOffice and in a second, independent engine and compares thirty-five values — day counts for requests that span a bank holiday, start on one and end in the next month, every balance on the sample team, and specific calendar cells including the pending request that must not appear — against numbers computed outside Excel.
First release
One row per application: company, role, stage, dates, next step. Days waiting and which applications need a nudge are calculated; active, interviews, offers and response rate are kept at the top. Pro adds a Pipeline sheet with conversion between stages and results by source, and a Follow-ups sheet that lists what needs doing. No macros.
Habits down the side, days across the top, a mark when you did it. Done counts, a monthly target scaled from your weekly one, completion bars, weekends shaded. Pro adds current and best streaks with the running count on its own sheet, a by-week view, and a formulas walkthrough. No macros.
One row per medicine with its strength, dose and the times of day it's taken; the week grid records doses actually taken and works out adherence against what was due. Pro adds a refill planner — units used a day, days left, the date it runs out and the date to order — and a dated dose log. A tracker, not medical advice. No macros.