ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   spreadsheet that assigns vacation based upon seniority/time off a. (https://www.excelbanter.com/excel-programming/317573-spreadsheet-assigns-vacation-based-upon-seniority-time-off.html)

lengleson

spreadsheet that assigns vacation based upon seniority/time off a.
 
I am in need of a spreadsheet that will assign vacation yearly based upon
seniority for employees (75) and time off allowed

Tom Ogilvy

spreadsheet that assigns vacation based upon seniority/time off a.
 
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.

--
Regards,
Tom Ogilvy


"lengleson" wrote in message
...
I am in need of a spreadsheet that will assign vacation yearly based upon
seniority for employees (75) and time off allowed





All times are GMT +1. The time now is 02:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com