I'm looking for an Excel template to track employee vacations. It will need
to be based on each individual's hire date. i.e. Joe was hired on March
1/04. He is eligible for 2 weeks vacation after his anniversary date on
March 1/05. He can take the 10 days (2 weeks) at any time in the year after
his anniversary and can take the vacation all at once, or split it up to 1 or
2 days here and there over the year until March 1/06. He MUST take all of
his alloted 10 days prior to his next anniversary date and cannot carry over.
I need to track 40 to 50 employees individually as well as view a summary
for each month. If anyone has any suggestions it would be very much
appreciated. Thank you.