Holiday Calculator FY27 - Download Copy

Overview

The Holiday Calculator for Accrued Vacation is used to determine eligible holiday hours that occur during an employee's accrued vacation period after their last day worked in an eligible position. The calculation considers the employee's available vacation balance and Full-Time Equivalent (FTE) percentage to determine and prorate applicable holiday hours.   The workbook includes accessibility features to support keyboard navigation and screen-reader users.

Instructions

Holiday hours due are calculated starting the day after last day worked in the eligible position and goes forward in time to include any holidays falling within the time frame of the employee's available vacation hours. Allocation of vacation hours per day is determined by the FTE percentage. Holiday hours are prorated based upon the FTE percentage. Refer to System Regulation.

NOTE: These instructions are the same for all supported versions of the Holiday Calculator for Accrued Vacation, including TAMU, TAMUQ, School of Law, and School of Dentistry.

The Holiday Calculator for Accrued Vacation is based on the Texas A&M University System's Vacation Regulation, which establishes the uniform administration of vacation leave for eligible employees in accordance with state law.
 

Using the Calculator

  1. Download and save a copy of the Holiday Calculator for Accrued Vacation before use.
  2. Enter information only in the designated input cells (highlighted in yellow):
    • Date of Termination (MM/DD/YYYY)
    • FTE%
    • Vacation Hours
  3. After the required information is entered, the calculator automatically calculates and displays:
    • Number of Days to Add
    • End Date
    • Total Holidays
    • Total Holiday Hours Due (PPR)

Review the calculated results to verify the employee's eligible holiday hours.

NOTE:   Only the designated input cells are intended for user entry.  All calculated fields are protected and automatically populated by the workbook.  Save a copy of the calculator prior to entering information.

Accessibility Features

The Holiday Calculator includes accessibility enhancements to support keyboard and screen-reader users.

  • An Accessibility Information worksheet is included to explain workbook navigation, inputs, and calculated results.
  • Navigation links are provided throughout the workbook to move between calculator worksheets and supporting information.
  • Input fields include validation to help prevent incorrect data entry.
  • Only designated input cells can be edited; calculated fields are protected from accidental changes.
  • Input fields are clearly identified and do not rely solely on color for identification.

NOTE: Holiday dates used in calculations are maintained within the Holiday Calculator workbook and are updated as necessary.

Resources

The following resources provide additional information related to this topic:

Print Article