PTO Tracker

[Baldylox81]

I would like to add an "Hours Available" column for both Personal "P" & Vacation "V" time to the attached PTO-Forum file.

The issue I am having is with creating a function that will add Anniversary hours (AF, AG) when the "Hire Date" (AD) < current date (Day and Month, excluding year). I should be able to then create a simple sum formula to add in "Cary Over" (B, C), less "Hours Used" (AB, AC) Columns.

Any help is greatly appreciated,

[Baldylox81]

I figured it out, I was to focused on Month and date and trying to exclude year. Simply needed to find day of the year and compare to current day of the year for desired result.
=AE11-DATE(YEAR(AE11),1,1)+1