+ Reply to Thread
Results 1 to 5 of 5

Non Accruing vacation/sick time

  1. #1
    Registered User
    Join Date
    06-26-2014
    Location
    Daytona, FL
    MS-Off Ver
    2007
    Posts
    5

    Non Accruing vacation/sick time

    Ok I need a formula that calculates vacation and sick time individualing. Employees automatically get 5 vacation days and 3 sick days every 6 months with and without rolling over. Is there a way to make it calculate automatically or do I have to go in and change the dates once a week or so? This is what it looks like now
    Sick Days Sick Sick From To Available Used Left
    Hire Date 6 Month Date Available Used Left
    Smoe, Joe 11/3/2008 5/16/2014 16-Nov-2014 6 2 4 10 6 4
    Baker, Cake 2/1/2002 1/1/2014 1-Jul-2014 3 3 0 5 5 0
    Last edited by dzitoicihomes; 06-27-2014 at 09:45 AM.

  2. #2
    Registered User
    Join Date
    06-26-2014
    Location
    Daytona, FL
    MS-Off Ver
    2007
    Posts
    5

    Re: Non Accruing vacation/sick time

    Sorry don't know how to get my example on here so it's easy to read

  3. #3
    Valued Forum Contributor
    Join Date
    01-19-2012
    Location
    Barrington, IL
    MS-Off Ver
    Excel 2007/2010
    Posts
    1,211

    Re: Non Accruing vacation/sick time

    What criteria is there for rolling-over versus not rolling over?
    Could you upload a sample spreadsheet? Click GO ADVANCED on the bottom, and click the Paperclip to upload.

  4. #4
    Registered User
    Join Date
    06-26-2014
    Location
    Daytona, FL
    MS-Off Ver
    2007
    Posts
    5

    Re: Non Accruing vacation/sick time

    Techinally we don't allow rollover unused time but it happens.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    06-26-2014
    Location
    Daytona, FL
    MS-Off Ver
    2007
    Posts
    5

    Re: Non Accruing vacation/sick time

    Offically we don't rollover unused time but it happens
    Attached Files Attached Files

+ 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. OMG Trying to Calculate Vacation and Sick Time
    By tlgeiger in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-19-2013, 10:51 AM
  2. Help with IF statement for accruing sick time
    By Bree in forum Excel General
    Replies: 0
    Last Post: 12-29-2011, 04:20 PM
  3. Replies: 2
    Last Post: 07-23-2010, 05:39 PM
  4. Calculating Vacation/Sick time
    By missmel159 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-24-2008, 05:45 PM
  5. Counting Vacation or Sick Days within a Specified Time Period
    By Rhonda Hewett in forum Tips and Tutorials
    Replies: 1
    Last Post: 08-23-2005, 12:37 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