Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calc staff vacation time based on more than 1 criteria Tacrier Excel Worksheet Functions 0 May 6th 10 05:58 PM
ASSOCIATE VACATION TIME SPREADSHEET - EXEL DEAN Excel Discussion (Misc queries) 1 March 24th 09 10:05 AM
I want a spreadsheet to track employee vacation/sick time hours Conitha Charts and Charting in Excel 0 June 20th 08 02:53 PM
How to allocate based on seniority Chunkey Pandey Excel Discussion (Misc queries) 6 November 24th 06 07:04 AM
How can I calculate Vacation Time earned based on length of emplo. Kim Excel Discussion (Misc queries) 2 March 15th 05 08:04 PM


All times are GMT +1. The time now is 08:18 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"