Reduce lead time, ensure quality and perfect your processĬreate schedules, manage crews and deliver under budget Share files, add comments, and work together in real-timeĬreate automated workflows and improve productivityįor small-to-medium teams that need to manage robust projectsįor medium-to-large teams that need to optimize portfoliosįor organizations that need customized security and priority support Organize and manage your tasks to boost team productivity Prioritize and execute your work with transparency and agility Generate in-depth, easy-to-read reports to share progress Manage portfolios, align objectives and get high-level overviews Set milestones, connect dependencies and track progressĬollect and view real-time data on your work for key insights

Use your custom legend to update the 2023 calendar for each employee.Learn more about ProjectManager and how it can improve your businessĭiscover app combinations that improve your productivity.

The calendar uses the formula “IF(COUNTIF(Holidays!$A$5:$A$15, Holidays!H7)>0, 'H', Holidays!H7)” to automatically add the holidays from Holidays worksheet to each employee’s calendar.

Return to the Calendar worksheet and add your employees and a brand new calendar for each of them.

Go to Legend worksheet and define your PTO types.

Also in the Holidays worksheet, introduce the calendar for the current year.

Go to Holidays worksheet and introduce your region’s public holidays and your company’s special holidays.

Download the free PTO Tracker and rename it to match your organization’s standards.

Check out the following steps to configure your PTO Tracker and start using it. As a result, we avoid adding unnecessary information and deliver a neat solution that saves you time and energy.

Easy to add employees and visualize their situations.Īn Excel-based PTO Tracker needs to be light and easy to use.

Automatic computations for each PTO type.

Changeable calendar so you can reuse the PTO Tracker template next year.

Compact calendar for 2023 with US holidays.

Covers vacations, public holidays, maternity and sick leave, and other types of PTO.Here’re the most important features of our free PTO tracking solution: Personalize it according to your company’s PTO policy and add important data such as the company’s name and employee identification data, public holidays in your region, company-related holidays, and PTO types. Our PTO Tracker is a time-saving and easy to use Excel spreadsheet.

Pto schedule excel template