+ 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
    Office 365 ProPlus
    Posts
    5,855

    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
    20

    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)

Similar Threads

  1. Excel PTO Accrual
    By debbsuchb in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-10-2019, 02:22 PM
  2. Replies: 1
    Last Post: 09-20-2018, 04:43 PM
  3. Replies: 4
    Last Post: 01-20-2015, 11:51 AM
  4. Replies: 1
    Last Post: 10-12-2013, 10:27 PM
  5. Excel Sheet to Calculate Complex Vacation Accrual and Use
    By sierraauto87 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-09-2013, 01:02 AM
  6. PTO accrual - 5 days per year - in excel
    By REALADY0920 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-14-2013, 12:26 PM
  7. Use Loop in Excel VBA to calculate accrual sum of revenue
    By gwen_2609 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-21-2011, 10:20 AM

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