1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need formula to calculate leave balance

Discussion in 'Ask an Excel Question' started by rkn, Feb 14, 2019 at 4:58 AM.

  1. rkn

    rkn New Member

    In attached file im trying to calculate casual leave balance of each month based on carry forward basis from previous and next month. Used IF conditions but not worked. Each month having 2 CL's and will add automatically once date criteria match. I need the following
    Example: Jan leaves should be deducted from 2018 balance leaves till zero. Feb leaves deduct from first 2018 balance(if any) then Jan balance then Feb balance.

    Attached Files:

    • FU.xlsx
      File size:
      404.8 KB

Share This Page