Results 1 to 6 of 6

Calculating Employee Leave Accrual

Threaded View

  1. #1
    Registered User
    Join Date
    09-01-2016
    Location
    South Carolina
    MS-Off Ver
    2013
    Posts
    6

    Calculating Employee Leave Accrual

    I need some help with leave calculations. The start date is the date they started with the company and this is the base for everything (it is in column "B")

    Second criteria is how long they have been with the company I used =(YEAR(NOW())-YEAR(Bxx))*12+MONTH(NOW())-MONTH(Bxx) to determine the months in column H

    The employee doesn't earn any leave until after 6 months. On the 6th month anniversary they automatically receive 12 days (96hrs) and an additional 2 days (16 Hrs) each month thereafter. Now if that were the end it would be simple with =IF(Hxx<6,0,Hxx*2) in column I. However, once at the employee reaches 12 months they are awarded 30 days with the maximum accumulation being 60 days.

    So if written out it would look like this:
    1-5 months = 0 days of leave
    6-12 months = 12 days plus 2 days per month (total for the first year 24 days)
    12 months and more = 30 days a year not to exceed 60 days.
    Note: The leave days do not accumulate when advancing in time. Example: if the employee uses 6 days during his 10th month with the company when he gets to one year he will have 24 days available.

    Once I get this, any leave taken can simply be subtracted from this total.

    Any questions let me know, thanks in advance for any assistance.

    Kyle
    Last edited by pknivens1; 09-01-2016 at 04:31 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 03-03-2015, 01:38 PM
  2. Assistance with Accrual and daily sick leave balances
    By JuanitaS in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-17-2014, 08:06 AM
  3. Employee Vacation / Holiday accrual spreadsheet
    By dzidek in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-24-2014, 05:35 PM
  4. employee vacation accrual and tracking template
    By Lundberg99 in forum Excel General
    Replies: 2
    Last Post: 04-01-2014, 08:49 PM
  5. Vacation and Sick Leave Accrual formula
    By Dowjd in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-01-2013, 10:24 PM
  6. Leave Accrual Spread sheet
    By Luphai in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-27-2013, 08:40 AM
  7. Annual leave accrual formula
    By Lebogang in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-08-2012, 07:56 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1