2027 Leave and Attendance
Holidays, leave and sick days for the whole team, with working days counted for you and the 2027 Italian public holidays already in.
File preview: click the tabs at the bottom to switch sheets
=SOMMA.PIÙ.SE(Assenze!$E:$E;Assenze!$A:$A;A4;Assenze!$D:$D;"Ferie")| A | B | C | D | |
|---|---|---|---|---|
| 1 | foglio=furboFerie e presenze 2027 | |||
| 2 | Celle verdi: da compilare · grigie: calcolate (protette) · dati di esempio | |||
| 3 | nome | giorni_spettanti | giorni_usati | residuo |
| 4 | Marco Rossi | 26 | 10 | 16 |
| 5 | Giulia Bianchi | 26 | 14 | 12 |
| 6 | Luca Ferri | 22 | 5 | 17 |
| 7 | Sara Conti | 26 | 4 | 22 |
What's inside
| 1. Istruzioni | The steps to follow, what to fill in and what not to touch. |
| 2. Dipendenti | Name, days allowed, days used (calculated) and days left. |
| 3. Assenze | Who, from when to when, and what type; working days are calculated. |
| 4. Festività | The 2027 public holidays, editable, plus your patron saint. |
| 5. Calendario 2027 | People × days, coloured by type of absence. |
Works with
Excel 2019 and Microsoft 365
Windows and Mac, .xlsx file. Formulas use Italian function names and the ; separator.
Google Sheets
Built in Sheets, not converted. "Make a copy" link, from your phone too.
No macros
No VBA or Apps Script to enable: it works as soon as you open it.
Tested before it's sold
Excel for Windows, Excel for Mac and Google Sheets. No errors on an empty file.
Questions about this template
Answers to the questions we get most often about the 2027 Leave and Attendance.
We reply within 2 working days.
Write to usWhich public holidays are included?
All the Italian national holidays for 2027, including 4 October (Saint Francis), plus a row for your city's patron saint. The Festività sheet is editable.
Does it count Saturdays?
No. The count skips Saturdays, Sundays and the holidays in the sheet. If you work Saturdays, you change a single number in the formula.
How many people can it handle?
It is set up for 25 people. Need more rows? Copy the last one.
Does it replace payroll software?
No. It keeps track in the office; the official figures are still the ones from your payroll consultant.
You might also need
"Organize 2027" Bundle
All 5 templates in one purchase: save €10.70.
2027 Goals Planner
Goals and progress month by month, with a status that updates itself.
Expense Report
Trips, meals and mileage in an expense report that's ready to print.