+ Reply to Thread
Results 1 to 5 of 5

Excel PTO Accrual Help

  1. #1
    Registered User
    Join Date
    06-10-2019
    Location
    Mt Pleasant, MI
    MS-Off Ver
    Excel
    Posts
    6

    Excel PTO Accrual Help

    I have everything in my Excel Sheet Correct EXCEPT when they take PTO it doesn't calculate accurately. Help. Please see attached Sheet.
    Attached Files Attached Files

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    2013, Office 365 ProPlus
    Posts
    3,898

    Re: Excel PTO Accrual Help

    Not sure what you are after... but I assume it's Balance.

    Try below in E4 and copy down.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    “Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.”
    ― Robert A. Heinlein

  3. #3
    Registered User
    Join Date
    06-14-2019
    Location
    Charlotte, NC, USA
    MS-Off Ver
    Office 365
    Posts
    6

    Re: Excel PTO Accrual Help

    Try this. Rolling balance = Prior Balance + Accrued PTO - Used PTO
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    06-10-2019
    Location
    Mt Pleasant, MI
    MS-Off Ver
    Excel
    Posts
    6

    Re: Excel PTO Accrual Help

    Quote Originally Posted by izzy-analytics View Post
    Try this. Rolling balance = Prior Balance + Accrued PTO - Used PTO
    You literally are a LIFE SAVER

  5. #5
    Registered User
    Join Date
    06-10-2019
    Location
    Mt Pleasant, MI
    MS-Off Ver
    Excel
    Posts
    6

    Re: Excel PTO Accrual Help

    Quote Originally Posted by CK76 View Post
    Not sure what you are after... but I assume it's Balance.

    Try below in E4 and copy down.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    OMG Thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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