• 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

    Hui...

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

Leave Balance to carry forwarded every month - Attendance Sheet

MaunishP

Member
Hi Team,
I would require a formula / dashboard where August we start our new year, where each employee is credited 2 leaves every month, now if any employee takes any leave in first month as per example Mr.A has taken 3 leaves in August now his leave balance should come -1, however rest employees havent taken any leave hence thier Leave balance should 2. This leave balance data should be carry forward every month in next sheet where each month 2 leaves are added and leaves are deducted if applied.

I am not able to carry forward leaves data every month and deducte if they have utlitized in any month.

Attached is file

Regards,
Maunish Patel
 

Attachments

  • Yearly Attendance Sheet.xlsx
    13.1 KB · Views: 52
Something like attached?

Edit: Does Name column order change and/or can name be removed in subsequent months? That will change formula a bit.
 

Attachments

  • Yearly Attendance Sheet.xlsx
    15 KB · Views: 92
Last edited:
Back
Top