Vacation and Sick Time Tracking Spreadsheet

Separate vacation and sick allowances per employee, with every absence logged and both balances recalculated automatically.

Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.

Category

Human Resources

Tables

Employees, Absences

Fields

20

Views

grid, calendar, kanban, form, dashboard

Tables, columns and sample rows

The 2 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.

Employees

9 fields · 4 sample rows

  • Balances (Grid)
EmployeeTextDepartmentSingle selectVacation allowanceNumberSick allowanceNumberAbsencesLink to another tableVacation usedRollupSick usedRollupVacation leftFormulaSick leftFormula
Ananya IyerEngineering18.08.020 Oct 2026, 10 Nov 202641147
Daniel OkaforSales15.010.05 Nov 2026, 17 Nov 202604156
Sana MirzaPeople18.08.015 Nov 202600.5187.5
Wei ZhangFinance14.014.029 Nov 202650914
Field details
Employee · Text
Department · Single select
Engineering, Sales, Marketing, Operations, Finance, People, Support
Vacation allowance · Number
Sick allowance · Number
Absences · Link to another table
Links to Absences
Vacation used · Rollup
sum of Vacation days via Absences
Sick used · Rollup
sum of Sick days via Absences
Vacation left · Formula
{Vacation allowance} - {Vacation used}
Sick left · Formula
{Sick allowance} - {Sick used}

Absences

11 fields · 6 sample rows

  • Log (Grid)
  • Calendar (Calendar)
  • By type (Kanban)
  • Report an absence (Form)
  • Absence trends (Dashboard)
FromDateEmployeeLink to another tableToDateTypeSingle selectHalf dayCheckboxDaysFormulaVacation daysFormulaSick daysFormulaApprovedCheckboxMedical noteAttachmentNotesLong text
20 Oct 2026Ananya Iyer24 Oct 2026Vacation440Yes
10 Nov 2026Ananya Iyer10 Nov 2026Sick101YesMigraine
5 Nov 2026Daniel Okafor7 Nov 2026Sick202Yes
15 Nov 2026Sana Mirza15 Nov 2026Doctor appointmentYes0.500.5Yes
29 Nov 2026Wei Zhang6 Dec 2026Vacation550Lunar New Year planning
17 Nov 2026Daniel Okafor18 Nov 2026Family care202Yes
Field details
From · Date
Employee · Link to another table
Links to Employees
To · Date
Type · Single select
Vacation, Sick, Doctor appointment, Family care
Half day · Checkbox
Days · Formula
IF(AND({From}, {To}), IF({Half day}, 0.5, WORKDAY_DIFF({From}, {To})), 0)
Vacation days · Formula
IF({Type} = 'Vacation', {Days}, 0)
Sick days · Formula
IF({Type} != 'Vacation', {Days}, 0)
Approved · Checkbox
Medical note · Attachment
Notes · Long text

Form view “Report time off” asks for: Employee, Type, From, To, Half day, Medical note, Notes.

Vacation and Sick Time Tracking Spreadsheet: questions

Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.

Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.

Related templates