G Guest Nov 22, 2004 #1 I am in need of a spreadsheet that will assign vacation yearly based upon seniority for employees (75) and time off allowed
I am in need of a spreadsheet that will assign vacation yearly based upon seniority for employees (75) and time off allowed
T Tom Ogilvy Nov 22, 2004 #2 create a table that shows years of service and days of vacation (if years of service is the governing factor). then you can get your number using a vlookup function. See help on vlookup for an explanation.
create a table that shows years of service and days of vacation (if years of service is the governing factor). then you can get your number using a vlookup function. See help on vlookup for an explanation.