+ Reply to Thread
Results 1 to 7 of 7

Employee Vacation / Holiday accrual spreadsheet

  1. #1
    Registered User
    Join Date
    07-22-2014
    Location
    Grantham
    MS-Off Ver
    2013
    Posts
    6

    Employee Vacation / Holiday accrual spreadsheet

    Hi All

    I need help with my spreadsheet. I used Excel 2013 template to create employee absence schedule but I want to add if they have enough accrued hrs/days.

    Currently, I need help with formula so their holiday balance is accruing every week.
    On a weekly basis employee is accruing 3.85 or 4 hrs (depends how long he worked for the company).
    Less than 5 years rate is 3.85 hrs and more than 5 years is 4 hrs.

    I attached example sheet for accruing vacation.
    E column is employee current balance from last week.

    Thanks
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Employee Vacation / Holiday accrual spreadsheet

    Please Login or Register  to view this content.
    Works out the accrual
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me

  3. #3
    Registered User
    Join Date
    07-22-2014
    Location
    Grantham
    MS-Off Ver
    2013
    Posts
    6

    Re: Employee Vacation / Holiday accrual spreadsheet

    Hi

    Thanks for a reply.
    I have tried and I must doing something wrong as doesn't work.
    What means @ in your formula?
    Also not too sure why you use [Years Worked].
    Sorry for dumb questions I'm only beginner.

    Thanks

  4. #4
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Employee Vacation / Holiday accrual spreadsheet

    Years worked and Holiday Accrual rate are your table headers. The @[sdfasdfasd] etc is using the table column names rather than the cell addresses.

  5. #5
    Registered User
    Join Date
    07-22-2014
    Location
    Grantham
    MS-Off Ver
    2013
    Posts
    6

    Re: Employee Vacation / Holiday accrual spreadsheet

    I've got your formula working but that's not what I'm looking for.

    What I need is to get a formula so every week (on Monday ideally) employee Holiday accrual hours balance is raising automaticly by Holiday Accrual Rate (4hrs or 3.85hrs).
    Example: Name 1 has got currently 103.89hrs of holiday available so next week should have 4hrs more 107.89.

  6. #6
    Registered User
    Join Date
    07-22-2014
    Location
    Grantham
    MS-Off Ver
    2013
    Posts
    6

    Re: Employee Vacation / Holiday accrual spreadsheet

    I just been searching forum and I did find that you helped here other guy and I used your formula but it still needs a bit tweaking.

    I adjusted this formula to my needs for name1 =103.89+((DATEDIF(B23,B24,"m")+IF(DAY(TODAY())<17,-1,0))*D2) but it calculates on a monthly basis and I need every seven days.
    B23: starting date
    B24: =today()
    D2: 4 (Holiday Accrual Rate (Hrs))

  7. #7
    Registered User
    Join Date
    07-22-2014
    Location
    Grantham
    MS-Off Ver
    2013
    Posts
    6

    Re: Employee Vacation / Holiday accrual spreadsheet

    anyone can help on this one?

+ 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. Vacation accrual spreadsheet
    By thesar805 in forum Excel General
    Replies: 7
    Last Post: 09-04-2017, 06:52 PM
  2. employee vacation accrual and tracking template
    By Lundberg99 in forum Excel General
    Replies: 2
    Last Post: 04-01-2014, 08:49 PM
  3. Replies: 3
    Last Post: 10-16-2013, 09:05 PM
  4. [SOLVED] Need Simple Vacation Accrual Spreadsheet
    By mrbsbest in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-29-2013, 10:18 PM
  5. Vacation Accrual Spreadsheet
    By jrace in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-16-2013, 05:28 PM

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