← Back to blog

Planning Leave Without Spreadsheet Chaos

Request leave, approve it, and see available days – including part-time work and public holidays.

Leave & absences HR & development

In many companies, leave is still planned in Excel spreadsheets. At first this looks clear: names, days, and perhaps remaining allowance sit next to one another. Once public holidays, different working days, or part-time work enter the picture, the list quickly becomes a calculation task. A week away does not mean the same number of leave days for everyone.

Someone working only three days a week should not be treated like a full-time employee for the same period. A public holiday should not accidentally be deducted from allowance. When those rules are maintained manually in a spreadsheet, they require constant attention and it can still be unclear which number is correct.

A request instead of a spreadsheet row

The leave feature therefore begins with a clear request form. People select the period they want and submit the request directly in their work context. An informal message or spreadsheet row becomes a traceable process: requested, reviewed, approved, or declined.

Approval is not administration for its own sake. It makes clear that leave is both personal planning and a decision for the team. Those responsible can review the request, and everyone involved has a clear current state afterwards.

Calculating available days correctly

The overview shows available leave days so a request can be assessed fairly. Public holidays are included in the calculation, as are personal working days: the system considers which days a person normally works.

That makes planning work for part-time staff without a special spreadsheet or manual arithmetic. A period away is not counted flatly; it is calculated against the days on which that person would actually have worked.

One shared view instead of several lists

After a decision, leave remains visible. People see their available balance and request status, while the team can see planned absences. Information no longer has to be reconciled between Excel, a calendar, and chat.

This does not replace team conversation. It gives it a reliable foundation: everyone plans from the same state.

Part-time friendly without becoming complicated

The design follows a simple idea: leave should be calculated the way work happens in everyday life. Personal working days and public holidays therefore belong in the basis of the calculation, not as an edge case. That makes the flow fairer for part-time staff and clearer for everyone.

Related articles