Vacation Tracker

A shared holiday calendar for the team: who is away, for how many working days, who is covering, and what is still pending approval.

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

Vacations

Fields

12

Views

grid, calendar, timeline, kanban, form, dashboard

Tables, columns and sample rows

The table in this template, with its real columns, field types and sample rows. Copy the template to edit it in Edesy Tables.

Vacations

12 fields · 5 sample rows

  • All time off (Grid)
  • Calendar (Calendar)
  • Timeline (Timeline)
  • Approvals (Kanban)
  • Book time off (Form)
  • Team view (Dashboard)
EmployeeTextTeamSingle selectTypeSingle selectFirst day offDateLast day offDateWorking daysFormulaBack onFormulaDestinationTextCoveringTextStatusSingle selectOut-of-office setCheckboxNotesLong text
Vikram RaoEngineeringVacation25 Nov 20262 Dec 202663 Dec 2026GoaAditi KulkarniApprovedYes
Chloe MartinSupportVacation19 Dec 20262 Jan 2027104 Jan 2027Lyon, FranceTom BeckerRequested
Neha KapoorSalesFestival leave17 Nov 202620 Nov 2026423 Nov 2026AmritsarJames WhitfieldApprovedYes
Lucas FernandesMarketingComp off22 Nov 202622 Nov 2026023 Nov 2026Divya PillaiApproved
Meghna DasFinanceVacation5 Dec 20269 Dec 2026310 Dec 2026DarjeelingDeclinedOverlaps year-end audit prep.
Field details
Employee · Text
Team · Single select
Engineering, Sales, Marketing, Operations, Finance, People, Support
Type · Single select
Vacation, Comp off, Festival leave, Unpaid
First day off · Date
Last day off · Date
Working days · Formula
IF(AND({First day off}, {Last day off}), WORKDAY_DIFF({First day off}, {Last day off}), BLANK())
Back on · Formula
IF({Last day off}, WORKDAY({Last day off}, 1), BLANK())
Destination · Text
Covering · Text
Status · Single select
Requested, Approved, Declined
Out-of-office set · Checkbox
Notes · Long text

Form view “Book a vacation” asks for: Employee, Team, Type, First day off, Last day off, Destination, Covering, Notes.

Vacation Tracker: 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