+ Reply to Thread
Results 1 to 3 of 3

Tracking Monthly Vacation Accruals and Usage in Excel 2010

  1. #1
    Registered User
    Join Date
    06-11-2012
    Location
    NJ
    MS-Off Ver
    Excel 2010
    Posts
    1

    Tracking Monthly Vacation Accruals and Usage in Excel 2010

    Hi everyone,
    I am knew to the group and would like to thank anyone in advance who might be able to assist me.

    I just started a new job and need to create and maintain a spreadsheet for our employees Vacation accruals. From there I will have to create different trackers for sick leave accruals and floating holidays. Fun stuff!

    Employees accrue 1.25 vacation days per month. Borrowing against future accruals is permitted.

    I purchased an Excel 2010 book this weekend, but am finding it difficult to interpret some of the text because I am apparently greener in Excel than what I realized!

    Have a terrfic day!

  2. #2
    Forum Contributor
    Join Date
    07-24-2009
    Location
    Valrico, FL USA
    MS-Off Ver
    Excel 2016
    Posts
    358

    Re: Tracking Monthly Vacation Accruals and Usage in Excel 2010

    Not sure if this will be helpful.
    It was made up to handle up 50 employees.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    02-18-2013
    Location
    lafayette IN
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Tracking Monthly Vacation Accruals and Usage in Excel 2010

    Hi - ncmay - i really like your attendance history file and it will work for me except for one thing. We are on a fiscal year July 2012-June 2013. Can you tell me how I can change that to calculate on a fiscal year?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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