vacation time

  1. M

    Vacation hours calculated by years of service

    I have two groups of ee's that have different vacation schedules. I want to use an if statement and a vlookup to determine the correct amount of vacation time for each group. What is the best way to accomplish this. I have attached a partial view of my spreadsheet data. Thanks.... MGR...
  2. T

    Vacation Time Error VBA Code

    Hello Everyone, I currently have a worksheet that will populate days with the initials of the Staff that has been assigned a task that begins and ends in a certain time frame. I've used an IF function for this. I now have another task I must do. My boss wants there to be an Error Message...
  3. S

    Vacation accrual

    Hello, I need help creating a vacation days tracking sheet. I Know this question MUST be answered a number of times over, however the examples I got when I searched are mostly based on hours. I need to accrue in days, and it starts the accrual after a 90 day probation following the hire date...
  4. B

    Need efficient way to track vacation dates taken

    Can anybody suggest efficient way to record vacation dates for dozen employees from three small departments and would this work as a line chart? Using 2010. Any suggestions, however brief, appreciated. :confused:
  5. B

    Vacation/Sick Time Excel Spreadsheet help!

    Hi! I'm not completely new to excel, been using it for years but for simple things. I can do some formulas but that's about it. So I have no clue how I can get this done! I saw a thread similar to what I need but with different specifications...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top