A vacation days tracker, free.
Track your own days off for 2027. Weekends and public holidays are skipped, half days count as 0.5, and it shows how many days you’ve got left.
✓ 100% free ✓ Instant download ✓ Excel for Windows & Mac
| First day | Last day | Type | Days |
|---|---|---|---|
| Mon 04 Jan | Fri 08 Jan | Vacation | 5 |
| Fri 12 Feb | Fri 19 Feb | Vacation | 5 |
| Wed 03 Mar | (half day) | Vacation | 0.5 |
| Mon 12 Apr | Tue 13 Apr | Sick | 2 |
| Mon 05 Jul | Fri 09 Jul | Vacation | 4 |
Simple, and the counting’s done for you
Days counted
Type the first and last day. Weekends and public holidays are skipped automatically.
Half days
Take half a day? Pick Yes and it counts as 0.5.
Days left
Your allowance, days used and days left, at the top.
Yours in under a minute
Click “Download it free”
You’ll go to a secure download page. There’s nothing to pay.
Enter your email
The download link is sent straight to your inbox, and you can download it straight away too.
Open it in Excel
Type your allowance, then your days off as you book them.
Free version or full version
The free tracker is for your own leave. The full Holiday & Annual Leave Tracker handles a whole team.
| Free | Full version · $9.99 | |
|---|---|---|
| Days counted without weekends and holidays | ✓ | ✓ |
| Half days | ✓ | ✓ |
| Days left | ✓ | ✓ |
| People | 1 | 25 |
| Month planner: who’s off when | – | ✓ |
| Approved, Pending and Declined | – | ✓ |
| Clash warnings | – | ✓ |
| 6 leave types you can set up | – | ✓ |
| Dashboard | – | ✓ |
Hi, I’m Lee
I run Sheet Leveller on YouTube, where I make quick, no-nonsense Excel tutorials. This free tracker uses the NETWORKDAYS formula from my tutorials, ready to use today.
Questions
Is it really free?
Yes. You just enter your email address so the download link can be sent to you.
Will you email me?
Now and then, with new Excel templates and tips. You can unsubscribe at any time with one click.
Does it use macros?
No. It’s a normal .xlsx file, so there’s nothing to enable and no security warnings.
Which versions of Excel does it work with?
Microsoft 365, Excel 2010 or later on Windows, and Excel for Mac.
Know how many days you’ve got left.
Download the free Vacation Days Tracker and plan your 2027.
Download it freeManaging a team? See the full Holiday & Annual Leave Tracker 2027.