Staff Annual Leave Tracker - Google Sheet

How to update

If you're using our free Google Sheet for tracking annual leave you may want to create a new copy for the coming year.

This is not strictly necessary, as the leave management sheet allows you to report on multiple years simultaneously, but your employees cannot have different allowances for different years. So if you need to keep track of a change in leave allowances, the best way to do this is to make a new copy every year.

Steps to update for next year

  1. Save a new copy of the Google Sheet so you don’t overwrite your current version.
  2. In the new copy, update the month and year in the Calendar sheet
Update leave year on Google Sheet
  1. Change the dates in the Employees sheet to reflect the new year
Google Sheet Update Step 2
  1. Clear the data in columns C to G in the Leave sheet, ensuring that you do not delete the column headings or the formulas in columns A or B.
Google Sheet Update Step 3
  1. That’s it, you have a fresh copy ready for the new year.

Need a better solution?

Leave Dates is the easiest way to track staff annual leave for free.

Try for free

We love the customer service.

We find that leave is now visible & up to date for all of our employees. We love the customer service that comes with using Leave Dates. It’s great for any small to medium size business looking to make leave visible across their business.

Simon Goble BankBI

Very simple to navigate and use.

The system as a whole is very simple to navigate and use. It doesn't try and do more than what it needs to do so there are no complex layers to try and find your way around. Everything is so streamlined that it makes it easy to learn and deploy.

Emmet H. Operations Manager