+ Reply to Thread
Results 1 to 2 of 2

Employee Leave Calculation

  1. #1
    Registered User
    Join Date
    07-29-2019
    Location
    Philippines
    MS-Off Ver
    2010
    Posts
    1

    Employee Leave Calculation

    Hi all!

    I've been having difficulty finding leave formulas for our employees.

    Every month upon date hired, EE will get 1.25 leave credits til end of year. So they'll get maximum of 15 leave credits in a year. After a year, they'll be reimbursed max 5 days worth of leave credits and the remaining will be used on the next year while still earning credits.

    Example:

    I was hired April 4, 2019. Upon December 2019, I'll have 9(months employed for year 2019) x 1.25 = 11.25 leave credits.

    Come my 1st year of employment, April 4, 2020, the management would first convert the 2019 leave credits (11.25) so if I didnt use them up, id still have 6.25 left.

    January 2020 up to April 2020, I accumulated 5 credits plus 6.25 from 2019 so I should have 11.25 as of this date.

    I find it difficult to have a clean spreadsheet for this as I'm just following the format of what I have since I got in the company and there were already a lot of formula changes in the file. Also, since the excel is too heavy to save all data of absences, I only have record of paid and unpaid leaves since 2019.

    Please see attached file for reference.


    Thank you so much!!!!!!
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    12,915

    Re: Employee Leave Calculation

    Hello jannamunion and Welcome to Excel Forum.
    In row 2 of the file attached to post #1 we see the results of the current formulas, which the note in row 5 indicates are not correct. I might help us come up with formulas/code if you could tell us with the correct results that those cells should display.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Tracking employee based on leave dates
    By sentinela in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-13-2020, 03:14 AM
  2. [SOLVED] Employee Leave Calculation
    By pknivens1 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-12-2016, 01:00 PM
  3. [SOLVED] Calculating Employee Leave Accrual
    By pknivens1 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-02-2016, 10:50 AM
  4. Replies: 5
    Last Post: 03-03-2015, 01:38 PM
  5. [SOLVED] Extract Leave dates for Employee with its type
    By rohit.r.p in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-09-2013, 08:01 AM
  6. Display annual Leave Dates by employee
    By janger in forum Excel General
    Replies: 4
    Last Post: 01-14-2012, 07:05 AM
  7. I need a template for Employee annual leave tracking
    By Pamela Aranguiz in forum Excel General
    Replies: 1
    Last Post: 01-11-2006, 09:40 PM

Tags for this Thread

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