G
GeorgieP
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.
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.